Sage 50 order Carriage Charge
Carriage Charge can be posted with an order very easily by simply specifying a few tags in the header of the Sage 50 Order
Example: Press Help, on the PostTrans toolbar, then select example “Posting Payment with Order” 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.
Example
Simply open a blank Excel spreadsheet and press Import button. PostTrans will then offer you all of the import tags to create a new PostTrans template. Double click on the PostTrans tag Sage50Trans. A new Order template will be created, now add some data:
To specify the Courier, Consignment Number, Carriage Net amount, Tax code and Carriage Nominal, select cell D6, then Double click on Tag THCarrCourierNo, in the PostTrans Tags side bar. Then add tags THCarrConsNo, THCarrNet, THCarrTaxCode and THCarrNomCode to give:
Thus when posted we see:
And in Sage 50 we see the Carriage Charge:
The following PostTrans tags allow the above functionality:
Tag Name
|
Data Type
|
Description
|
THCarrCourierNo
|
Text
|
Carriage Courier Number
|
THCarrConsNo
|
Text
|
Carriage Net Amount, else value in Sage 50 SOP Settings
|
THCarrNet
|
Text
|
Carriage Net Amount, else value in Sage 50 SOP Settings
|
THCarrTaxCode^
|
Text
|
Carriage Tax Code, else uses Account Default
|
THCarrDepartment^
|
Text
|
Carriage Department, else value in Sage 50 SOP Settings
|
THCarrNomCode^
|
Text
|
Carriage Nominal Code, else value in Sage 50 SOP Settings
|
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