Each client only has one item price file, 2 importing and two replacements. I will attach the files you asked for.
Ahold is one other client I do weekly. I can work on that later just wanted to let you know.
With the replacement and item price files I do make adjustments often. New stores and items are added at random times. Also, prices can change for individual distributors at random times.
The price file refers to the price we charge the distributor. There are times the distributor can sell an item at a discount and I do not know ahead of time.
When there is a discount or a product is sold below full price, we add the items into the accounting program at full price then we create a line item as it is called within the accounting program ‘very similar to an item”. The line item is the total discount of all the items discounts added together.
Albany does not supply us with the price they sell the product for. I have asked them many times but they tell me it is not possible. They are in the process of deploying a new system and tell me once that gets deployed, they will be able to. They have been deploying this system new system for over a year and I am still waiting. I have not needed this feature with them yet and not sure if I will.
The distributors are businesses we hire to deliver our products. They determine the product codes and names. The distributors do not change often. I have worked here two years and in the last two years they have stayed the same. Prices are determined when our Chief Marketing Officer talks with the store management, that is also how discounts are put into place. With flexibake I have control over prices and names.
The distributors receive a percentage of the total sales.
The accounting program we use is call Quickbooks Enterprise version. The program I use to upload the data is called transaction pro.
The flexibake data comes from an ERP program I am deploying for our in-house drivers and other distributors that do not currently use handheld devices. They currently give us paper invoices. As of right now I only have flexibake handheld devices deployed to the in-house drivers. I am hoping to get this to the other distributors within the next month. I am first waiting for the ERP company “Flexibake” to add a credit identification number to the paper print out before I can deploy it to other distributors. We have 15 other distributors that all use paper invoices. These have 1-5 drivers each. We have 2 in-house drivers.
50% of our sales are on paper invoices. This is one main reason I was hired. To eliminate the paper.
Reply With Quote