Coding non-PGG/ruralco/farmsource supplier invoices
D
Diana Baird
Hi... Thought I would let you know a work around. It is a bit convoluted, but it works!
We have a local shop and also the Vet club which we buy a lot of varied product from, and I want to split the transaction into multiple categories. They both send monthly statements out in PDF form.
This is how I construct a CSV file so that all the lines can be picked up by Focus.
- Download statement
- Open file using Word
- Open old, already loaded transaction file (I use a PGG rile) in excel.
- Copy transaction lines from Word file and paste into the PGG csv excel file (beneath the previous transactions... leave them there until you have checked everything)
- Make all the columns correspond... i.e. copy and paste to get the amount and description into the right column
- Make sure there are no merged cells
- delete all non-transaction lines (e.g. summaries, invoice totals etc) and of course the old PGG lines... but leave the column headings.
- Save as a CSV file
- Go into Focus, download file as a "PGG" file (or rural co or farmsource... whatever the original transaction file you used was).
- Make sure the statement date is correct and CHANGE THE OTHER PARTY NAME
- Upload and code as normal for "PGG"!
Saves me a lot of paper, pencils, and head scratching! And of course you can use coding rules as well.
Log In
J
Jane-Farm Focus
Hi, Thanks for being in touch. We are aware that users can manipulate other supplier invoices into a format that is supported by our import function. This is not best practice but we will include your process in a Help Centre resource 'How to import your PGG Wrightson or Ruralco statement' Thanks for your ongoing custom.
Farm focus
Hi Diana, thank you for your helpful tips here. Our other users will find this very handy.