Sales Reporting in Accpac and RMS

Hi

Just a point of interest

I may be using a wrong field but I have written extensive sales reports using Accpac OE generated from RMS.

The company I wrote for uses an inclusive price as their master in IC, so be aware that if this is the case the report field in Alchemex "Line Total Excluding" actually is the gross price inclusive of vat and a formula using the "Line Tax " must be deducted to get the net amount

I also discovered that the credit note cost field that uses the table OECRDD.EXTICOST returns 0, I modified this to read the OECRDD.EXTCCOST

This worked for me so , I thought I would share it.

Regards

Derek Sevel