Iptor IP1 uses book industry standard Digital Sales Report (DSR) format as the standard sales order interface for all incoming sales data. Incoming sales data from different sources will be processed by IP1 to generate sales transactions, update sales information and generate debtor transactions. The generated transactions in IP1 from the DSR sales data interface will be used in the sales analysis, product profitability, and the processing of the payment by the online stores to the publishers. The data will also be used in the generation of the royalty earnings and payment.
If Royalties, Rights, Permissions and Contracts module is active, the DSR sales will be part of the normal sales journals that IP1 generates since the DSR sales will be same as normal distribution sales transactions.
Interface programs within IP1 can automatically update Royalties, Rights, Permissions and Contracts. These updates can be based on an interface trigger controlled by the user or scheduled to run on a predetermined frequency which can be on an hourly/daily basis or as required by the user. Specific data queues that are setup for IP1 to Royalties, Rights, Permissions and Contracts updates and vice versa must be activated.
IP1 can also use the same interface to handle transaction types that are not related to online stores e.g. Consignment Sales and Distributor Sales
Incoming ONIX data can be imported into IP1 to update product data or create new products on approval. Similarly outgoing data can be generated for specific products and stored as XML files and pushed to customers as required.
ONIX data can be exported to XML files from IP1 using any of the following methods.
- manual process
- based on an interface trigger controlled by the user
- scheduled to run on a pre-determined frequency which can be on an hourly/daily basis or as required by the user
The incoming ONIX data (XML file – stored in a pre-defined folder in the system) can either be imported manually into IP1 or scheduled to run as a batch process.
Process flow – DSR
- An Excel template (DSO415.xlsx) with all the relevant system fields that are required in the processing of the interface file is provided. This template and Excel date file must exist in the relevant system folder.
- Flag in the Excel file the relevant columns that relate to the system fields.
- Run Sales Upload program (DSO415).
- The system will process the Excel input and generate AR, AP and G/L interface files.
- Generated AR and AP/GL interface files can be enquired on and validated before it is posted. (DSW070/AGW005).
- There are 4 different sales report types as listed below. Each of these types will have mandatory and optional field requirement. Depending on the report type, the back end process can be different when the transactions are posted to IP1.
- Online sales – this is a charge only invoice since the products have already been delivered and there is no need to update stocks in the warehouse.
- Consignment sales – this is an already delivered sale that requires decrementing of stock in the consignment warehouse.
- Distributor sales – this is an already delivered sale that requires updating of stock in the distributor specific warehouse.
- POD charges – this will generate an AP invoice to the POD supplier for the print and customer delivery service.
