Please advise what the specification fields are for an O/E invoice subtotal which would include items being sold, a miscellaneous charge to one account (i.e. freight charge) as well as a credit (payment) to another account. For the subtotal I have tried using F14 Total gross excluding misc charge & tax nothing is working out. Also the payment received which I had set at F16 doesn't indicate the correct amount.

We are a manufacturer and some of the retail fields do not apply to our products.

E.G. Product 504.00
Freight Chg 80.00
Deposit -252.00
Final Payment -361.20

Subtotal should be 584.00 Invoice shows 504.00
GST/HST 29.20 29.20
PST 0.00 0.00
Payment Rec'd (613.20) (533.20)
Total 0.00 0.00


Help would be appreciated very much. Please contact me at office@accro-acmechrome.com

Thanks, Margot Clark\
Accro Furniture Industries

To see the numbers in every field available for a custom form, print the document using the "ALL Codes" specification and see which field contains the number you are looking for.

If no field contains the number you want, please describe exactly how you would want the number calculated, and what you would like it to be called and we will try and add it in the next Service Pack.

Hi Andrew, I have probably gone through ALL the codes 100++++ times in the last 6 years which is why I FINALLY contacted you. BTW Eva Froese is NO help with this. I listed what we need so if one of your technicians can figure out how to get that it will be greatly appreciated. What we have been doing is entering the freight charge as an item and then at the end of the month making a journal entry in the G/L to enter in the correct account because you can't have negatives (payments) and a positive (freight or postage charge) and then get the correct amount owing.

We have a new person in the accounting department and she is still learning the software modules so I'm trying to figure out all the nuances to be able to help her.

Aren't you glad you are living in Vancouver - it SNOWED again last night!

Hoping to hear from you again soon. Thanks, Andrew.

Margot Clark

Margot:

What you want to do can be done but the solution is not just a matter of finding the correct specification codes, I'm thinking that the way you enter the deposit and final payment will need to be changed as well.

If your current Adagio consultant is unable to assist you then there are lots of other consultants who can.

Doug, why would it have to be changed?

Because there is a complex interrelationship between how the information is entered and how it is presented on the forms.

So, for example, are you coding your freight charge as a miscellaneous charge or an inventory item you sell? You mention "deposits", but Adagio does not do deposit management, so you have a methodology of tracking those and the payments are coded externally somehow. Since we do not know how those have been implemented at your specific site, we cannot suggest how best to proceed.

Yes, we're entering the freight charge as a positive Miscellaneous Charge coded to one account and then a cash payment (deposit) as a negative Miscellaneous Charge (i.e. -$250.00) to another account.
Thanks, Andrew.