• Registered: 11/07/2012
  • Posts: 7

Topic: Purchase Orders & Net Pricing

Hi All

I have looked everywhere for a solution to this issue but to no avail ;(

I currently have over 3000 items on my system and only utilising the Purchase Order module until all products have been put in place.

My issue is I place all items on at "Net Price" however when I print off a Purchase Order the 20% Vat has been included in the pricing meaning the system thinks I have added the items at "Gross Price". What I actually want for VAT purposes is to continue to upload all items at "Net" and the VAT of 20% is added at the end of the process once I have finalised my Purchase Order.

What am I doing wrong? Just to add I uploaded all items via CSV, is there a way I can adjust this sheet to compensate for this?

Thanks in advance for any help.

Dan

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: Purchase Orders & Net Pricing

Please check that price is not tax included on the supplier.

Joe

  • Registered: 11/07/2012
  • Posts: 7

Re: Purchase Orders & Net Pricing

Hi Joe

I've located the "prices contain tax included" whilst editing suppliers as suggested, but it seems not to be editable and stuck on "Yes".

Any recommendations?

Thanks

Dan

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: Purchase Orders & Net Pricing

This is not meant to be editable for safety reasons. However you can change it by using the phpMyAdmin and go into suppliers table and set the value tax_included to 0.

  • Registered: 11/07/2012
  • Posts: 7

Re: Purchase Orders & Net Pricing

Thanks Joe, I have tried to look for "phpMyAdmin" and not able to find it. Is this something I need to download to my servers? I have FTP access and was not able to locate this.

Thanks

Dan

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: Purchase Orders & Net Pricing

PhpMyAdmin is a web based tool to manage MySql databases.

It should be available at your server. Contact you service provider.

Joe

  • Registered: 11/07/2012
  • Posts: 7

Re: Purchase Orders & Net Pricing

Hi Joe, I have managed to access the "phpMyAdmin" via my server and noted that the "Tax Included" is already set at "no". with this in mind is it possible for me to edit the suppliers I have already added as some have been set to yes by mistake. If its not possible, would there be any issue by me deleting the supplier and creating another record or will this interfere with the Purchase Orders I have already created?

Thanks

Dan

  • Registered: 11/07/2012
  • Posts: 7

Re: Purchase Orders & Net Pricing

Hi Joe

Ive sorted it, i edited each supplier individually via the phpmyadmin and all is working. Thanks for your help.

Dan

  • Registered: 08/14/2013
  • Posts: 8

Re: Purchase Orders & Net Pricing

i read the whole forums one by one but still not clear all the stuff. So is there any user modules for beginners of FA?

Thank you

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,106

Re: Purchase Orders & Net Pricing

No, but please read the Wiki .

Joe