Home > Accounts > Screen Shots/Explanations > Bulk Account Adjustments

Bulk Account Adjustments

This function can be used to make account adjustments across many accounts at once.

Figure: Example Bulk Account Adjustments Screen

The parameters for the function are as follows:


The system will look for specific locations within this location. For each of these locations, the system will determine the account location (as per the Accounts tab in Locations). It will process the accounts for each of these account locations. So if you specify ALL, this would find all the stores within ALL. For each of these stores, it will look up the account location. This provides a list of unique account location codes which can be processed.  


The trading terms of the accounts to be processed.

Adjustment Code

This is the adjustment code to be used for the adjustment.

Transaction Location

The specific location that will be recorded on the adjustment. If you were doing a set of transactions from head office for each store, you would specify the head office location code.

Adjustment Type

This determines the type of adjustment the system will perform.

Specific Amount

You should also enter the Amount.

Clear Balance

This will reset the balance of the account to zero. For example, you might have staff accounts where they are entitled to a certain account value to spend on meals each month. You can use this function to clear the balances at the start of each month.

Clear Expired

This will create an adjustment to the value of the expired transactions. You can use this to clear expired loyalty points. If the total expired points are 100, the system will create an adjustment for that value. You should also enter the Expiry Date and Expiry Time when selecting this adjustment type.

Reward Vouchers

This will create an adjustment to the Member Points accounts allowing points to be redeemed for vouchers.


If you select Specific Amount as the Adjustment Type, this is the value of the adjustment. Whether the amount is treated as a debit or a credit will depend on the Adjustment Code selected.  

Expiry Date/Expiry Time

If the Adjustment Type is Clear Expired, you need to enter the expiry date to compare the transaction to. Any transactions with an expiry date less than or equal this date/time will be expired.

Reward Voucher

If the Adjustment Type is Reward Voucher and as part of a loyalty system, as a member earns points, you can automatically redeem the points for vouchers. The member can then use these vouchers to pay for a sale. For example, you may redeem every 200 points for a $10 voucher.

Reward Points

The number of points required to receive a voucher. Multiple vouchers can be issued. If the customer has 700 points and a voucher is issue for every 200 points, the system will issue three vouchers.

Voucher Value

The monetary value of the voucher.

Export to Mail Merge File


You can also run this function as an EOD job as follows:

MerchantEOD.exe ACCOUNTADJ ledger location termcode adjustcode translocation adjtype amount expirydate expirytime


The account ledger code, for example MEMPTS


Adjustment type 1=Charge/Fee, 2=Clear Balance, 3= Clear Expired


The amount for the charge/fee. This should be number with no currency symbol or thousand separator. If adjtype <> 1 then set as 0


Date of expiry as YYYY/MM/DD. If you are running from Process Jobs this can be a parameter like $TODAY.


Time of expiry in 24 hour time (HH:NN). leave as 00:00 for midnight


MerchantEOD.exe ACCOUNTADJ MEMPTS ALL M EXPIRED SHOP1 3 0 2009/12/20 06:00

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)