Retail-Control Mechanism

navimbs

Hi,

I have the retail scenario as below:
LS Retail is implemented at one location(with POS Shops & Back Office) using Navision SQL Server database. Company uses Oracle Apps(Oracle database) for its financial operations. All invoices from LSR db are exported in flat files to OA database. The user needs a control mechanism(a flag/control) in Navision database to verify how many invoices are successfully exported & how many failed.

How can we arrive at this solution? Request your inputs.

Thanks,

Best regards,

ara3n

By Successfully Exported, you mean successfully imported in OA?

I would see if it's possible to create a web service on OA.
In navision you would call the webservice, and it would return orders that are successfully imported.

navimbs

Let me reframe my question.

Consider LS Retail databases, one ABC in Store location & one XYZ in HQ location. Invoices are replicated from ABC to XYZ database.

How can we keep a control in ABC database to check if the invoices have been transferred successfully or not?

Regards,

navimbs

Hi Rashed,
Thanks. I believe i could not read you well earlier.
Its not know yet but i believe it is going to be by invoking a web service via biztalk. Though m not much aware, it will pick documents in xml format as orders.

Regards

ara3n

You can also create a separate job that replicates the transaction status table back to stores. The Transaction header has a flowfield to this table. I'm guessing you are posting the statements in Headquarter, so by replicating the this table back, the store can see which orders have not been posted yet.

navimbs

Hi Rashed,

I would request if you could kindly explain this to me in more detail.

What is a web service? How can we call the web service throgh Navision SQL? (will be highly obliged if u could kindly send me any supporting document if available)

The connectivity has to be between Navision SQL Server database & Oracle database. The interface/applcn developed in navision will execute in navision. I should have this interface to tell - how many invoices are successfully IMPORTED(from Oracle database), how many invoices have FAILED to transfer?

The navision system should be able to maintain the status & should be able to list invoices, provide reasons for failure, and allow corrections & audit trail.

Thanks,

Best Regards,

navimbs

Are you talking about data exchange in the form of XML files through XML ports with Biztalk in a 3-tier architecture?

ara3n

Here is an example on how to call a webservice from your Oracle system.

http://www.mibuso.com/forum/viewtopic.php?t=23618