Can anybody help me set up an application for the following?
I sell modular products that are sold by sales codes. Each sales code may contain 10 or so stock components. So if I sell 10 sales codes it may contain say 60 stock components.
When I make a list of the order, the codes displayed will be the stock codes, these will be summarised to show the total qty for that stock codes. The 10 sales items sold may have 10 stock codes the same with variable qty�s so when the stock list is displayed all the codes are summarised thus reducing the needs to show the same code more than once.
I have created my stock component table that has sales codes, stock codes fixed component qty and description. I have a sales code table that has sales code, description and price etc. If I manual filter the sales code I can get all the stock codes listed.
I have the Invoice Header table set up and in the invoicing screen I can select my products and qty no problem. I have a few issues with the posting method but I am confident the Alpha Sports application with help sort this out.
The issue I can�t resolve is the sales to stock codes issue � I need to create a customer order table that lists the stock codes for each customer, not the sales codes.
Has anybody had any experience creating tables for an application that uses sales codes to make the sale but uses stock codes to handle the order, picking and despatching off the inventory totals.
Help!
Andy
I sell modular products that are sold by sales codes. Each sales code may contain 10 or so stock components. So if I sell 10 sales codes it may contain say 60 stock components.
When I make a list of the order, the codes displayed will be the stock codes, these will be summarised to show the total qty for that stock codes. The 10 sales items sold may have 10 stock codes the same with variable qty�s so when the stock list is displayed all the codes are summarised thus reducing the needs to show the same code more than once.
I have created my stock component table that has sales codes, stock codes fixed component qty and description. I have a sales code table that has sales code, description and price etc. If I manual filter the sales code I can get all the stock codes listed.
I have the Invoice Header table set up and in the invoicing screen I can select my products and qty no problem. I have a few issues with the posting method but I am confident the Alpha Sports application with help sort this out.
The issue I can�t resolve is the sales to stock codes issue � I need to create a customer order table that lists the stock codes for each customer, not the sales codes.
Has anybody had any experience creating tables for an application that uses sales codes to make the sale but uses stock codes to handle the order, picking and despatching off the inventory totals.
Help!
Andy
Comment