Programmers/Coders are by necessity, extremely pedantic. One missed punctuation mark, a typo, or misused syntax can ruin one's entire day. Please try to be more pedantic.

I just spent three hours analyzing the Procedures in six workbooks you use to convert the raw data from three Distributors/Clients into Invoice and Return files for uploading into the accounting program, so I am a little salty. The three clients are Albany, MidState and Flexibake. Their Raw Data files are Albany.csv, Midstate.xls, and Flexibake.unk. Flexibake has the bad Return Invoice Number.

Each client appears to have several workbooks associated: 2 @ Importing, 2 @ Prices, 2 @ Replacements, and of course, their Raw Data Files. Are there any I missed?

I have the Importing and Replacements workbooks for those three clients, can you upload the rest for those three? Just those three, for now, I am trying to get my head around a universal or generic Data Structure.

What is the ultimate purpose of the Replacements lists? Are these lists needed permanently, or will the new values eventually show up in the Raw Data?



Ideally, the Price lists should refer to the current values in the Raw Data files and include

  1. All Product codes
  2. All Product Name/Descriptions
  3. All Sell Prices
  4. All Return prices (even when Sell and Return are the same value)
  5. Discontinued Item (a single character will suffice. ["a", 1, or "T"])


I will be modifying all that into one workbook with a sheet for each Client with the columns

  1. Product code
  2. Replacement Code
  3. Product Name/Description
  4. Replacement Name
  5. Sell Price
  6. Replacement Sell Price
  7. Return price
  8. Replacement Return Price
  9. Discontinued Item

Then I will write some simple Procedures so anyone can import a list of changes/edits and have the list applied.

BTW, are your Distributors/Clients child businesses of your company? If so who sets/determines Product codes/names/prices? This knowledge would change the above desires/requirements




Finally. I am only really familiar with two accounting programs; MS Excel and GnuCash. What Accting Software do you use?