Missing Items

niteshnav · 2006-03-27

Hi,

This is a typical retail scenario. I have the frequent problems with the missing items at the HQ & the stores location. The Invoices are imported into the HQ database daily from another oracle database system. The invoices are regularly exported from the HQ to the Local native databases on scheduler.

1. Often, the invoice carries an item that is missing in the system(HQ).
2. The item is scanned at the stores location(local native), and finds item missing in the system.

How can the situation be handled?

regards,
Nitesh

kriki · 2006-03-28

Create also an emport/import for items.

Now you have 2 possibilities:
1) In the table items, create an extra date-field "Date Exported". When you change an item, clear this field again, so the changes are exported again.
Before exporting the invoices, export also all items with a blank "Date Exported". Before importing invoices, import first all items

2) In the table items, create an extra boolean-field "To Be Exported". When exporting invoices, put the new field to TRUE for the exported item-invoice lines, afterwards you export also these items ("To Be Exported"). When importing, you should first import the items and then the invoices. You can also use the "Date Exported"-field and export only if "To Be Exported"=TRUE and "Date Exported"=0D.

niteshnav · 2006-03-28

Condition:

There is a batch job running at the stores & the HQ for deletion of items which have not been used over a period of time(eg. for last year)

The invoices exported/imported into the native db might contain items which are missing in the item table.
Note: There is no relation between the item table & the Invoices table. Since the invoices are coming to the HQ db from an outside database.
How is the relation be established while importing items & invoices to the native db? It is a separate EDI invoice table, that ports to the respective navision invoice tables.
Or else we create items at run time during import to the native? [need to know the feasibility/parameters on which default items with minimum information be created as to include in invoices]

regards,
Nitesh

kriki · 2006-03-28

niteshnav wrote:

Or else we create items at run time during import to the native? [need to know the feasibility/parameters on which default items with minimum information be created as to include in invoices]

There are few fields really necessary (like the posting-fields to calculate VAT) for an item, so this you can do (it depends on which fields you need to know and which fields you get, not only on which fields Navision needs).
But keep in mind that all items should have the same posting-fields (or you should recognize at the information on the invoice lines which values you have to give the posting-fields).

Missing Items

Comments

Categories