Dynamics Community Forum Thread Details

Non Trade Debtors and Creditors

Hi I am implementing Dynamics GP 2010. The business is pretty straight-forward and the set up is vanilla - except for the various sundry creditors and debtors. The company acts as an agent for a number of small farmers, so there are numerous advances, payments on behalf of these farmers. Also the farmer may have multiple business relationships with the company, doing various roles, such as transporting, selling or loading produce to the company. I have a few thoughts on how to set this up, but any ideas would be gratefully received.

Regards

Alistair

Hi Alistair,

I've a good bit of experience in the agricultural sector with GP. Not sure exactly what you need in terms of an answer, but:

I have one customer who handles the multiple relationships through setting up a Debtor for each activity and using the National Accounts functionality in GP. Another who uses Inventory Service Type items for each service the farmer offers - and just one Debtor account (The also use a seperate SOP Invoice Type ID to differentiate the different services eg: LOADINV for Loading Invoices, TRANSINV for transportation invoices etc.).

Also Farmers tend to be creditors as well (purchasing supplies from you etc) - so Debtor / Creditor consolidations are also used.

Typically farmers are issued with a combined Statement/Invoice at month end. This summarises the transactions since the last Statement/Invoice and analyses the sales tax etc.

Another complication is when Farmers do work for ou and ou handle their paroll taxes (rather than paying a Purchase Invoice). We have situations where the Farmer 'timseheets' get created a PM Invoices and then feed into an export to an external Payroll module....the actual bank payment coming back to clear the PM invoice.

The above might give you a few pointers. But if ou have more specific questions ou might post again.

Best regards,

Ian.

Quick Links

Leaderboard