Selling on Account

Dec 20, 2006 2 Replies

Hi All, I have set up a new tender type called "Store Account". I have also setup my store accounts (10 stores) so we can sell goods to each other. Goods are sold at cost+GST (tax in Australia). The cost in the system is Ex Tax so we calculate the cost + GST manually and then change the item price on screen at the POS to be this figure per line item. I have developed accurate profit margin and gross profit reports to see how we are tracking. Even with the stock standard (inaccurate) reports for sales which show profit margin, how will the selling of goods on store accounts affect the reported GP, profit margin when the invoice is closed,ie, payment in full is made?


rather than manually calculating the selling price, you could use one of your price levels (A, B & C) - you can use the inventory wizard to set these level prices in bulk using a formula and assign the selected level to your customer accounts so they are automatically applied.

Profit reports have to be calculated using actual selling price and item cost at the time of sale - this is recorded for each line item of each sale in the TransactionEntry table. The data is there, but I have no idea how it may affect your customized reports.

If you normally sell Tax Exclusive, why are your store to store sales Tax Inclusive? Never mind - I just barely understand the tax system here in the US and I live with it every day....

Why not just use HQ and interstore transfers?

Glenn Adams Tiber Creek C> Hi All,

Hi All, I have set up a new tender type called "Store Account". I have also setup my store accounts (10 stores) so we can sell goods to each other. Goods are sold at cost+GST (tax in Australia). The cost in the system is Ex Tax so we calculate the cost + GST manually and then change the item price on screen at the POS to be this figure per line item. I have developed accurate profit margin and gross profit reports to see how we are tracking. Even with the stock standard (inaccurate) reports for sales which show profit margin, how will the selling of goods on store accounts affect the reported GP, profit margin when the invoice is closed,ie, payment in full is made?

-- Regards

Dan Levin

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required