PostTrans can handle Sage 50 overall transaction value discount, or Qty based discount, by simply adding you own formula to calculate the overall discount on the header of the transaction.

Example: Press Help, on the PostTrans toolbar, then select example “Apply discount to whole transaction” which is the example discussed below.  You should also have read the "Importing Transactional Data" on the Training page for a basic understanding of PostTrans basics.

Thus if we take our standard Sales Order template:

We can select cell C7, and then add tags THNetDiscount and THNetDiscDesc to the template:

Thus we could enter a formula in cell D7 to calculate a 10% discount if transaction net is over £500 ( in cell I7, Total Net )

=IF(I7>500,0.1,0)

And in Cell C7

=I7*D7

And then in C8

=IF(C7>0,"Discount:"&(D7*100) &"%","")

So we now have

And if we post this to Sage 50 we get:

Also see the discount section of “Sage 50 file importation”

Tags of interest

The following PostTrans tags allow the above functionality:

Tag Name	Data Type	Description
THNetDiscount	Text	Net Discount Value applied to whole transaction, as shown at the bottom of Sage 50 Order.
THNetDiscDesc	Text	Net Discount Description

With data type Yes/No fields, if cell starts with 'y' or 'Y' is taken as TRUE

Where ^ denotes a Code Search field (Popup search window), delete ^ at end of tag, to turn off code search