EXPORT/IMPORT OF ITEM PRICING

[AHJS]

Hi Community

I need some help please on Pricing Levels in AccountRight. @Steven_M (I have tagged you in as you tend to explain things in a way that we understand if you are able to help, sorry it's that's a bit presumptuous)

I need to do a bulk export and import to establish a new pricing level for a new customer which we export to.  We have had all sorts of problems having the pricing show EX GST so our work around is to create a new pricing level for them with GST exclusive prices so....

When I export, the price levels on the exported data are not matching what we seeing on the item card.  Can someone please clarify for me?

We currently have 6 Price Levels on the Item Cards, only C (Labelled DIST AUS) and D (DIST EXP) are currently active.  We only have the price level in that qty over is always 0 so just the one qty break of price levels (?) as per the screen shot for my dummy example

When we export our Price Levels Break 1, the figures do not match what we are expecting to see as per the screen shot of the result of my dummy example.

ie Price Level C (DIST AUS) S/BE $12.50 but it exports as $24.95

Now we have some 2613 items (side note how can you exclude inactive items from export), over half return results as we expect.  The rest have varying qty breaks and therefore the correct prices are showing under different qty breaks fields (some upto 5).  But we have never had any invoicing issue with incorrect pricing pulling through as what is on the screen on the item card pulls through to the sale.

Is my understanding of price levels/breaks incorrect or is there something wrong with the set-up of our items?  How can I do a bulk export and import of data given the results we are getting?

Thanks in advance

AJHS

[Steven_M · Accepted solution]

Hi @AHJS 

I've seen the odd thing happening before with other company files and exports it generally indicates that the file may need to come in for a repair.

However, before we go down that road, I have some concerns with the second screenshot you have taken (i.e. the Excel one), have you modified the columns headings in that report i.e. you have DIST instead of DIST AU, EXP instead of DIST EXP? Perhaps as test export, all the item fields out instead of just the Price levels required does it generate the required export?

[AHJS]

Sorry Steven, I forgot to report back.  A few more "stranger things" happened and our company file went off to be repaired.