As a manufacturer's rep, I rep about twenty different manufacturers. I need to be able to build a report that tells me the gross margin I make on each manufacturer's products. Currently, I can see gross margin on each invoice through the Commission Report, of course, but there's no way to compile that data by my different manufacturers. If there was a field on the AR Invoice Data Entry screen where I could assign the manufacturer's name to each invoice, I could later build a Crystal Report from that field and see how much money I'm really making on each vendor's products. Currently I've coopted the Ship Method field and used that for this purpose, but it's imperfect at best because the Ship Method field isn't restricted and accepts anything you type-so if my invoicing person miskeys, the report quickly becomes corrupted. An extra restricted data field on the AR screen that I could preset with only a list of my vendors would be most helpful. Alternatively, simply making Ship Method a restricted field would work-we don't use it anyway.
by: Richard K. | over a year ago | Reports / BI
Comments
Richard.
you might look in the help files on User defined tables/fields. your comment is a perfect example of how User Defined Fields and Tables can be used. If you still need help contact your reseller or Sage directly for additional guidance.