This chapter discusses how to:
Create bills of lading and shipping manifests.
Create advanced shipping notices.
Create internal location expected receipts.
Create interunit expected receipts.
Print shipping reports.
Create shipping excise invoices for India.
A bill of lading lists all items in a shipment destined for a particular ship to location. A shipping manifest lists all items in a given shipment, regardless of ship to address. You can combine bills of lading into shipping manifests.
When you create a new bill of lading or shipping manifest, you can enter a number or accept the default of NEXT. If you accept NEXT, PeopleSoft Inventory generates a number based upon the default setup in the Automatic Numbering page. If you select NEXT and no default sequence has been defined, the system displays an error.
See Also
Defining Inventory User Preferences
Setting Up Automatic Numbering
Page Name |
Object Name |
Navigation |
Usage |
BOL_HDR_INV |
Inventory, Fulfill Stock Orders, Shipping, Build Bill of Lading |
Create foreign or domestic bills of lading. |
|
BOL_SEL_INV_SP |
Click the Search button on the Bill of Lading page. |
Select orders to add to the bill of lading. |
|
INV_ADDRESS |
Click the Address link on the Bill of Lading page. |
View address information. Note. You cannot use this page to override the address. |
|
BOL_DETAIL_INV |
Inventory, Fulfill Stock Orders, Shipping, Build Bill of Lading, Domestic Details |
Calculate or enter the shipping weight and volume, by commodity code, for domestic shipments. |
|
BOL_DETAIL_EXP_INV |
Inventory, Fulfill Stock Orders, Shipping, Build Bill of Lading, Export Details |
Calculate or enter the shipping weight and volume, by harmonized code, for export sales orders or export intercompany transfers. |
|
BOL_EXPORT_INV |
Inventory, Fulfill Stock Orders, Shipping, Build Bill of Lading, Export Info |
Define consignee and transport information for export sales orders and export intercompany transfers. |
|
BOL_NOTE |
Inventory, Fulfill Stock Orders, Shipping, Create Bill of Lading Notes |
Define standard notes to print on a bill of lading. Note. This page is only available if the installation includes PeopleSoft Order Management. |
|
BOL_MANIFEST_INV |
Inventory, Fulfill Stock Orders, Shipping, Build Shipping Manifest |
Consolidate bills of lading onto a shipping manifest. |
Access the Bill of Lading page.
To create a bill of lading:
Click the Search button to access the Bill of Lading Order Selection page, where you select orders to include on the bill of lading.
Demand lines meeting the search criteria appear in the scroll area in the lower portion of the page.
Select a bill of lading type.
Different kinds of orders are eligible for each bill of lading type:
Domestic |
Domestic sales orders and material stock requests that are not export orders. |
Foreign |
Export sales orders and export intercompany transfers.
Note. Export intercompany transfers are only available to include on the bill of lading if they have been marked for export on the order header. |
Foreign and Domestic |
All sales orders and material stock requests. |
Note. PeopleSoft Inventory supports the creation of foreign bills of lading only for intercompany transfers. If the installation includes PeopleSoft Order Management, you can also create bills of lading for other foreign shipments.
Select the check boxes for the demand lines that you want to include.
To include all displayed lines, click the Select All button; to remove all lines, click the Deselect All button.
Click the Validate button to add the selected lines to the bill of lading and to remove other orders from the scroll area.
This action also displays various other fields, depending upon whether you are building a domestic or foreign bill of lading.
Click the Print link to print the Bill of Lading and Shipping Manifest reports from this page.
Note. You can only print the Shipping Manifest report from this page if the bill of lading has a shipping manifest number.
See Also
Access the Bill of Lading Order Selection page.
For domestic bills of lading, you must enter either a ship to or a location and carrier ID. For foreign or foreign and domestic bills of lading, you must enter an order number.
Whether or not you enter a specific carrier ID, the system also returns orders with no defined carrier ID. If you add one of these orders to the bill of lading, PeopleSoft Inventory updates the carrier information for the order.
Access the Domestic Details page or the Export Details page.
To enter additional bill of lading information:
Enter or calculate shipping information, using either the Domestic Details page or the Export Details page.
Calculator |
Click to enable PeopleSoft Inventory to calculate the Shipping Weight and Shipping Volume. These values are calculated using either the commodity code (for domestic shipments) or the harmonized code (for foreign shipments) assigned to the item, along with the shipping unit of measure (UOM), the shipping weight UOM, and the shipping volume UOM. You define this information on the Define Item - General: Dimensions page. |
Enter consignee and transport information for export sales orders and export intercompany transfers on the Export Info page.
All of the information on this page is optional, and much of it comes from customer information defaults, business unit defaults, and either the sales order or the intercompany transfer.
Enter any notes for the shipment on the Bill of Lading Notes page.
See Also
Access the Build Shipping Manifest page.
To create a shipping manifest:
Enter a business unit, shipping manifest number, carrier ID, or BOL Print Date (bill of lading print date), then click the Search button to find bills of lading that match these parameters.
Select the check box next to a Bill of Lading number to add it to the shipping manifest.
To add all returned bills of lading, click Select All; to clear all check boxes, click Deselect All.
Click the Bill of Lading Print button to print the selected bills of lading or the shipping manifest from this page.
See Also
The Advanced Shipping Notice (ASN) message is an asynchronous outbound batch publish EIP to notify your customers that a sales order has been shipped. This message is passed to an external system or to the PeopleSoft CRM Field Service and CRM Order Capture applications. The Advanced Shipping Notice EIP meets X.12 EDI requirements of the 856−Shipping Notice/Manifest transaction set, and is also used with warehouse management systems. An ASN message is generated when a sales order entered from PeopleSoft Order Management has been depleted in PeopleSoft Inventory. You can specify whether to generate the ASN for all sales order shipments in the business unit, sales orders belonging to a specific shipping ID, sales orders for a specific sold to customer, or sales orders for a specific ship to customer.
The system does not create an ASN under these circumstances:
The shipment has not been through the Deplete On Hand Qty (Depletion) process.
The order is a drop ship or is for non-inventory items.
The transaction has a demand source other than PeopleSoft Order Management.
PeopleSoft Order Management is not installed.
See Also
Page Name |
Object Name |
Navigation |
Usage |
Batch Publish Rules |
EO_MSGPUBATCH |
Enterprise Components, Integration Definitions, Batch Publish Rules |
Set up publication rules. You must activate a publish rule for the publication messages you create to follow. This rule includes instructions on message chunking, if necessary. |
Add Nodes to Chunk Rule |
EO_ADNODECHUNK_PNL |
Enterprise Components, Integration Definitions, Map Chunking Rules, Node to ChunkRule |
Map PeopleSoft Application Messaging nodes to chunking rules. (A node is a PeopleTools object that represents a publishing or subscribing system on the message network. A message node often relates to an application server or database name.) |
Contact |
CONTACT |
Customers, Contact Information |
Maintain information about each contact. |
Contact Customer |
CONTACT_CUST_PAGE |
Click the Contact Customer Information link on the Contact page. |
Build the relationship between the contact and the different customer IDs the contact serves or is associated with. If the contact is only associated with one customer, enter that customer on this page. If the contact is a broker, for example, use this page to establish the relationships with the multiple customers that the broker serves. Set up security options on the Self Service Security tab. |
Inventory Definition - Business Unit Options |
BUS_UNIT_INV5 |
Set Up Financials/Supply Chain, Business Unit Related, Inventory, Inventory Definition, Business Unit Options |
Turn on the Advanced Shipping Notices EIP by selecting the Use Advanced Shipping Notice check box. |
Advanced Shipping Notices Selection Criteria |
IN_RUN_SHPNTC_ASN |
SCM Integrations, Publish Outbound Messages. On the Publish Outbound Message page, select the Advanced Shipping Notices check box, and then click the Advanced Shipping Notices link. |
Generate an ASN transaction to notify customers that a stock has been shipped. |
To use the Advanced Shipping Notice EIP:
Setup in PeopleTools:
Activate the ADVANCED_SHIPPING_NOTICE message. If using message chunking then set up the OnRouteSend PeopleCode Event on the message as follows:
Declare Function GetNodes PeopleCode FUNCLIB_INEIP.PUBLISH_ROUTE_PC FieldFormula; GetNodes (" ");
Setup an outbound asynchronous transaction defining the ADVANCED_SHIPPING_NOTICE message on each node that will receive the transaction. This step is only required if an XML message is being generated. This step can be skipped if the batch publish rule is set up to post to a flat file.
Verify the ADVANCED_SHIPPING_NOTICE message channel is in Run mode.
Setup in Enterprise Components:
Activate the ADVANCED_SHIPPING_NOTICE batch publish rule. Specify the appropriate output for the message (XML-based message or flat file). If you want to use message chunking select a Chunking Rule ID on the batch publish rule.
Setup the chunking rule mapping definitions if message chunking is to be used.
Setup at the Application Level:
Select the Use Advanced Shipping Notice check box for the business unit on the Inventory Definition-Business Unit Options page
Associate customers receiving the Advanced Shipping Notice EIP messages with an ASN document code and a preferred communication value of XML Only or XML and Print. If PeopleSoft Order Management is installed, then define these values on the Contact Additional Info page in the Maintain Contact component.
Setup if Using Chunking: Chunking is only needed if you have requirements to break up the messages and send them to different destinations based on attributes in the message such as business unit or customer ID. The most common use of chunking with the ASN message is to send a single customer’s messages to a specific node set up for that trading partner. If you are using a middleware product to actually determine trading partner destinations then a single message with all trading partner transactions can usually be sent directly to the middleware product. You would not need to activate message chunking in this situation. For an example of how to use Chunking look at the batch publish rules for the ADVANCED_SHIPPING_NOTICE message. These batch publish rules were provided as examples to show the power of message chunking.
The ADVANCED_SHIPPING_NOTICE batch publish rule is the standard rule used without chunking. If you want to chunk by:
Business Unit: Attach the BUSINESS_UNIT chunk rule to the batch publish rule. You would also have to populate the Business Unit to node values in the chunk table and set up the OnRouteSend Routing Rule on the message when you activate it in the Application Designer.
Ship To Customer: Activate the ASN_SETID_SHIPTO batch publish rule. In this case you also need to populate the customer chunk rule table and set up the OnRouteSend Routing Rule.
Sold To Customer: Activate the ASN_SETID_SOLDTO chunk rule, populate the customer chunk rule table and set up the OnRouteSend Routing Rule.
The above setup instructions assume that the message environment has been set up in PeopleSoft Integration Broker.
See Also
PeopleSoft Integration Broker PeopleBook
PeopleSoft Enterprise Integration PeopleBook
Access the Advanced Shipping Notices Selection Criteria page.
All Shipments |
Select to generate this transaction for all sales order shipments that have been through the Deplete On Hand Qty (Depletion) process, but have not previously generated an ASN. |
Sold To Customer |
Select to generate this transaction for a sales order with a specific sold to customer. |
Ship To Customer |
Select to generate this transaction for a sales order with a specific ship to customer. |
Specific Shipping ID |
Select to generate this transaction for sales orders with a specific shipping ID. |
Source Bus Unit |
Select a valid source business unit. A source business unit is the PeopleSoft Order Management business unit that created the sales order. This field is required if you elect in the Selection Options group box to generate this transaction for a specific sold to or ship to customer. This field is not available for entry if you elect in the Selection Options group box to generate this transaction for all shipments, or for a specific shipping ID. |
Sold To Customer |
Select a valid sold to customer. This field is only available for entry and is required if you elect in the Selection Options group box to generate this transaction for a specific sold to customer. |
Ship To Customer |
Select a valid ship to customer. This field is only available for entry and is required if you elect in the Selection Options group box to generate this transaction for a specific ship to customer. |
Shipping ID |
Select a valid shipping ID. This field is only available for entry and is required if you elect in the Selection Options group box to generate this transaction for a specific shipping ID. |
Re-Generate Message |
Select this option to regenerate a message for sales orders that have already been sent out. |
Note. When you navigate to the process monitor and wait till the process completes successfully, you can click the Details link and then the View Log/Trace link. This shows the output file as a link. The system generates the flat file to reflect the ASN information for the corresponding shipping ID.
The Internal Location Expected Receipt message is a asynchronous outbound EIP that sends a receipt transaction when an internal material stock request is depleted. Internal material stock requests are created to fulfill demand from a storage location within the Inventory business unit. Typically, you use the Internal Location Expected Receipts EIP when integrating with third-party point-of-use (POU) supplier systems or surgical resource management systems that manage supplies stored in internal par locations. The third-party system can use the data contained in the transaction message to manage receiving and restocking activities at the destination location. The Internal Location Expected Receipts EIP meets X.12 EDI requirements of the 944 − Warehouse Stock Transfer Receipt Advice transaction set and is also used with surgical resource software and point of use applications.
Page Name |
Object Name |
Navigation |
Usage |
IN_RUN_SHPNTC_IL |
SCM Integrations, Publish Outbound Messages. Select Internal Location Exp Receipts check box on the Publish Outbound Message page to enable the Internal Location Exp Receipts link. Click the Internal Location Exp Receipts link. |
Launch the Internal Location Expected Receipts outbound transaction for internal issue orders that have been depleted. |
To use the Internal Location Expected Receipt EIP:
Setup in PeopleTools:
Activate the INTERNAL_LOC_EXPECTED_RECEIPT message. If using message chunking then set up the OnRouteSend PeopleCode Event on the message.
Setup an outbound asynchronous transaction defining the INTERNAL_LOC_EXPECTED_RECEIPT message on each node that will receive the transaction.
Verify the INTERNAL_LOC_EXPECTED_RECEIPT message channel is in Run mode.
Setup in Enterprise Components:
Activate the INTERNAL_LOC_EXPECTED_RECEIPT batch publish rule. Specify the appropriate output for the message (XML-based message or flat file). If you want to use message chunking select a Chunking Rule ID on the batch publish rule.
Setup the chunking rule mapping definitions if message chunking is to be used.
Setup at the Application Level: Select the Use Internal Expected Receipt check box on the Inventory Definition - Business Unit Options page.
Setup if Using Chunking: Chunking is only needed if you have requirements to break up the messages and send them to different destinations based on attributes in the message such as business unit or location. If you want to chunk by:
Business Unit: Activate the INTERNAL_LOC_EXPECTED_RECEIPT batch publish rule and enter the BUSINESS_UNIT chunk rule. You would also have to populate the Business Unit to node values in the chunk table and set up the OnRouteSend Routing Rule on the message when you activate it in the Application Designer.
Business Unit and Location: Activate the INTERNAL_LOC_EXPECTED_RECEIPT batch publish rule and enter the BUS_UNIT_LOCATION chunking rule. In this case you also need to populate the BUS_UNIT_LOCATION chunk rule table and set up the OnRouteSend Routing Rule.
The above setup instructions assume that the message environment has been set up in PeopleSoft Integration Broker.
See Also
PeopleSoft Integration Broker PeopleBook
PeopleSoft Enterprise Integration PeopleBook
Access the Internal Location Expected Receipts Selection Criteria page.
Note. You can launch the internal location expected receipts outbound transaction only for PeopleSoft Inventory business units that have enabled the Use Internal Expected Receipt option on the Inventory Definition - Business Unit Options page.
All |
Select to generate an expected receipt for all internal issue shipments in a business unit. |
Specific |
Select to generate an expected receipt for internal issue shipments for a specific shipping ID. |
Shipping ID |
Select a shipping ID. This field is available for entry only if you elect in the Shipment Selection group box to generate an expected receipt for a specific shipping ID. |
Location |
Select a location option for which you want to generate an expected receipt. Options are: All Locations: Select to generate an expected receipt for all locations. All Par Locations: Select to generate an expected receipt for all par locations. All Par Locations for Unit: Select to generate an expected receipt for all par locations for a specific business unit. Specific Location: Select to generate an expected receipt for a specific location. Specific Par Location: Select to generate an expected receipt for a specific par location. Specific Par Location Group: Select to generate an expected receipt for a specific par location group. |
Location Code |
Select a location code. This field is available for entry only if you elect in the Location field to generate an expected receipt for a specific location. |
Source Bus Unit (source business unit) |
Select the source business unit that created the internal issue order, usually represented by the par location business unit. This field is available for entry only if you elect in the Location field to generate an expected receipt for all par locations for a specific business unit, for a specific par location, or for a specific par location group. |
Par Location ID |
Select a par location ID. This field is available for entry only if you elect in the Location field to generate an expected receipt for a specific par location. |
Par Location Group |
Select a par location group ID. This field is available for entry only if you elect in the Location field to generate an expected receipt for a specific par location group. |
Re-Generate Message |
Select this option to regenerate a message for orders that have already been sent out. |
Note. Select the Re-Generate Message check box to create a second internal location expected receipt message for a selected shipment. This option is for instances where the destination node did not receive the original message.
See Also
Activating Optional Business Unit Features
The InterUnit Expected Receipt message is an asynchronous batch publish EIP that notifies a third-party system that an Inventory business unit has shipped an interunit transfer order. The Interunit Expected Receipt EIP meets X.12 EDI requirements of the 943 − Warehouse Stock Transfer Shipment Advice transaction set and is also used with warehouse management systems. Interunit transfer orders are created in PeopleSoft to move stock between Inventory business units. Typically, you use the Interunit Expected Receipt EIP in integrated implementations in which a third-party system is controlling an Inventory business unit. A message is generated when an interunit transfer order with a destination business unit that is under external warehouse control is depleted. The third-party system can use the information from the interunit expected receipt message to validate the receipt of goods when the shipment arrives at the destination warehouse.
Interunit transfer orders are created in PeopleSoft to move stock between business units. Typically, you use the Interunit Expected Receipt EIP in integrated implementations in which a third-party system is controlling an Inventory business unit. An interunit expected receipt message is generated when an interunit transfer order with a destination business unit that is under external warehouse control is depleted. The third-party system can use the information from the interunit expected receipt message to validate the receipt of goods when the shipment arrives at the destination warehouse.
Page Name |
Object Name |
Navigation |
Usage |
IN_RUN_SHPNTC_IU |
SCM Integrations, Publish Outbound Messages. Select Interunit Expected Receipts check box on the Publish Outbound Message page to enable the Interunit Expected Receipts link. Click the Interunit Expected Receipts link. |
Launch the Interunit Expected Receipts outbound transaction for interunit transfer orders that have been depleted and not yet received. |
To use the InterUnit Expected Receipt EIP:
Setup in PeopleTools:
Activate the INTERUNIT_EXPECTED_RECEIPT message. If using message chunking then set up the OnRouteSend PeopleCode Event on the message.
Setup an outbound asynchronous transaction defining the INTERUNIT_EXPECTED_RECEIPT message on each node that will receive the transaction. This step is only required if an XML message is being generated. This step can be skipped if the batch publish rule is set up to post to a flat file
Verify the INTERUNIT_EXPECTED_RECEIPT message channel is in Run mode.
Setup in Enterprise Components:
Activate the INTERUNIT_EXPECTED_RECEIPT batch publish rule. Specify the appropriate output for the message (XML-based message or flat file). If you want to use message chunking select a Chunking Rule ID on the batch publish rule.
Setup the chunking rule mapping definitions if message chunking is to be used.
Setup at the Application Level: Select the Use External Warehouse Control check box on the Inventory Definition-Business Unit Options page.
Setup if Using Chunking: Chunking is only needed if you have requirements to break up the messages and send them to different destinations based on attributes in the message such as business unit or location. If you want to chunk by business unit, then activate the INTERUNIT_EXPECTED_RECEIPT batch publish rule and enter the BUSINESS_UNIT chunk rule. You would also have to populate the Business Unit to node values in the chunk table and set up the OnRouteSend Routing Rule on the message when you activate it in the Application Designer.
The BUSINESS_UNIT chunking rule may be overridden with a custom chunking rule if the business units used for the INTERUNIT_EXPECTED RECEIPT EIP have different node designations then that set for other messages. You must also assign the IN_DEST_BU_EOV alternate chunk table to the Batch Publish Rule. This entry is needed because the BUSINESS_UNIT chunk table is keyed by a field named BUSINESS_UNIT and when you chunk by the destination business unit, the Batch Publish Utility needs to match the business unit values entered in the BUSINESS_UNIT chunk rule with the values in the DESTIN_BU field on the Interunit Expected Receipt Header segment (IN_IU_ER_HD_EVW.DESTIN_BU). The Alternate Chunk Table entry on the Batch Publish Rule is used by the Batch Publish Utility to identify this type of situation. The IN_DEST_BU_EOV record is prepackaged for this purpose.
The above setup instructions assume that the message environment has been set up in PeopleSoft Integration Broker.
See Also
PeopleSoft Integration Broker PeopleBook
PeopleSoft Enterprise Integration PeopleBook
Access the Interunit Expected Receipts Selection Criteria page.
Transactions |
Select New to generate an expected receipt for new interunit transfer orders that have been depleted but not sent out in a previous message. Select Closed/canceled to generate an expected receipt for interunit transfer orders that have been previously sent in a message and have subsequently been closed or canceled. |
Shipments |
Select All to generate an expected receipt for all shipments for a business unit. Select Specific and enter a Shipping ID to generate an expected receipt for a specific shipping ID. |
Shipping ID |
Select a valid shipping ID. This field is available for entry only if you elect to generate an expected receipt for a specific shipment ID. |
Destination Unit |
Select All to generate an expected receipt for all destination business units. Select Specific to generate an expected receipt for a specific destination business unit. |
Unit |
Select a valid destination business unit. This field is available for entry only if you elect to generate an expected receipt for a specific destination business unit. |
Re-Generate Message |
Select this option to regenerate a message for orders that have already been sent out. |
Note. Select the Re-Generate Message check box to create a second interunit expected receipt message for selected shipments. This option is for instances where the destination node did not receive the original message.
Depending upon your business requirements, you may need to print shipping documents, bills of lading, shipping manifests, packing slips, and other reports for PeopleSoft Inventory shipments.
Print Bar Code or Print Bar Code on Report Flag |
Select to print a bar code on the report. For the Bill of Lading report, this bar code is made up of the business unit and bill of lading number fields concatenated. For the Packing Slip report, the bar code prints only for interunit transfers and consists of the business unit, interunit ID, interunit line, and destination business unit fields concatenated. For both reports, the bar code can be used for the Interunit Receipt EIP. Establish the default setting on the Setup Fulfillment component. |
See Also
PeopleSoft Enterprise Integration PeopleBook
Defining Basic Fulfillment Defaults
Staging Interunit Transfers Using an Electronic Data Collection System
Page Name |
Object Name |
Navigation |
Usage |
RUN_INC6503 |
Inventory, Fulfill Stock Orders, Shipping Reports, Shipping Document |
Print a copy of the orders and order lines shipped in a particular shipping ID. |
|
RUN_INS6100 |
Inventory, Fulfill Stock Orders, Shipping Reports, Bill of Lading |
Print both domestic and foreign bills of lading defined in the Build Bill of Lading component. |
|
RUN_INS6200 |
Inventory, Fulfill Stock Orders, Shipping Reports, Shipping Manifest |
Print shipping manifests defined on the Shipping Manifest page. |
|
RUN_INS6500 |
Inventory, Fulfill Stock Orders, Shipping Reports, Packing Slip |
Print packing slips for all confirmed stock requests in a business unit or for an individual order number. The bar code prints on this report only for interunit transfers. |
|
RUN_INS6600 |
Inventory, Fulfill Stock Orders, Shipping Reports, Export Pro Forma |
Create the Export Pro Forma report, a special invoice often requested by European customs officials to verify consignment details for export and import duty clearance. Note. Unless you select a specific order, the report extracts all shipped sales orders and intercompany transfers belonging to this business unit and shipping ID (including those that have not yet been depleted). |
|
RUN_INS6700 |
Inventory, Fulfill Stock Orders, Shipping Reports, Defer Invoicing |
Generate a query for all shipments that have not yet been invoiced. This report enables you to monitor your compliance with Italian law regarding deferred invoicing for shipments within Italy or involving third parties. This report can also be used for any similar requirements. |
|
RUN_OMC6114 |
Inventory, Fulfill Stock Orders, Shipping Reports, Canada Customs Invoice, Canada Customs Inv |
Generate the appropriate reports for orders requiring a Canadian customs invoice. Note. Before you can print this report, you must run the Export Doc Tbl Load page (export document table load page). |
|
RUN_OMC6112 |
Inventory, Fulfill Stock Orders, Shipping Reports, NAFTA Cert of Origin |
Generate documentation for orders requiring a NAFTA origin certificate. Note. Before you can print this report, you must run the Export Doc Tbl Load page. |
|
RUN_OMC6111 |
Inventory, Fulfill Stock Orders, Shipping Reports, U.S. Certificate of Origin |
Generate documentation for orders requiring a U.S. origin certificate. Note. Before you can print this report, you must run the Export Doc Tbl Load page. |
|
RUN_OMC6113 |
Inventory, Fulfill Stock Orders, Shipping Reports, Shipper's Export Declaration |
Generate export declaration documentation for orders. Note. Before you can print this report, you must run the Export Doc Tbl Load page. |
|
RUN_OMS6110 |
Inventory, Fulfill Stock Orders, Shipping Reports, Load Export Doc Table |
Initiate the SQR that reads all of the bill of lading and shipment tables and then loads the data for the corresponding bills of lading into the OM_EXPORT_DOC table (the master table for the export documentation reports). |
This section discusses how to:
Enter a shipping excise invoice for India.
Print a shipping excise invoice for India.
For shipments from a business unit located in India, the shipping excise invoice performs tax determination and tax calculation based on information from the IN_DEMAND table where all inventory shipments are recorded. Create a shipping excise invoice for India whenever Indian excise duty applies to a shipment from a PeopleSoft Inventory business unit for these transactions:
Sales orders from PeopleSoft Order Management.
Interunit transfers (material stock requests) moving stock between two different tax locations within PeopleSoft Inventory.
Return to Vendor transactions.
Before you can create a shipping excise invoice, you must define these parameters:
Add one or more excise document number series to create a unique serial number for each shipping excise invoice when saved.
If Depletion Check is selected on the Tax Location - Excise Group page for the PeopleSoft Inventory business unit, then the Deplete On Hand Qty (Depletion) process must be completed for the Shipping ID line before you can create the shipping excise invoice. If Depletion Check is not selected, then the shipping excise invoice can be created before you run the Deplete On Hand Qty (Depletion) process.
Note. If only sales tax is applicable, you cannot create a shipping excise invoice. Even without an excise invoice, the system still calculates sales tax in PeopleSoft Order Management and Billing. A shipping excise invoice is only necessary if excise duty is applicable to the shipment.
To create a shipping excise invoice:
Access the Shipping Excise Invoice page, enter the PeopleSoft Inventory business unit and the excise document number series for the new shipping excise invoice.
If you are changing an existing shipping excise invoice, enter the PeopleSoft Inventory business unit and select by excise invoice number. To update a shipping excise invoice, it must have a status of New. Shipping excise invoices that are in Ready or Post status can be viewed but not updated.
On the Shipping Excise Invoice page, click the Add New Lines link to access the Select Shipping Lines page.
Use the Select Shipping Lines page to find and select the shipped items to be added to the excise invoice. You can search by ship to customer, customer address, source unit, location code, bill to customer, order number, and shipping ID. After entering the search criteria, click the Search button to display available shipping lines. Select the lines to be added to the excise invoice and press the Return key to include the shipping lines on the Shipping Excise Invoice page. All lines added to one shipping excise invoice must have the same Tax Transaction Type. One shipping excise invoice could contain shipping lines from more than one shipping ID. Also, the lines from one shipping ID could be split between different shipping excise invoices. If the sales order includes a product kit, then the order must be shipped by using only one shipping ID; otherwise, PeopleSoft Billing cannot properly invoice the order. A product kit order cannot be shipped with multiple shipping IDs.
On the Shipping Excise Invoice page, review and enter data, then save.
If a valid tax rate code is found, the tax amounts are calculated when you return to the Shipping Excise Invoice page. If a tax rate code is not found, you must select one manually and click the Calculate Tax button. Taxes are also calculated when you save the page. If the setup allows the shipping excise invoice number to be overwritten, then the user can enter a user-defined value for the invoice number. Alternately, the system can assign a unique excise invoice number based on the excise transaction type and the excise document number series that you entered and saved on the shipping excise invoice.
If you add additional lines to the shipping excise invoice after saving, click the Calculate Tax button to recalculate the excise duty for the new lines that you added.
Once you have saved the shipping excise invoice, you can print a copy to accompany the shipment.
In order to print the shipping excise invoice, you need to set the status of the invoice to Ready. You can only print invoices that have a status of Ready or Post.. The invoice is printed when you click the Print button on the Shipping Excise Invoice page or on the Excise Invoice Report process page. Once printing is complete, the Print flag is set to Y, and any additional prints are identified as duplicates.
When the Register Update process completes the Excise Quantity Register Update subprocess, then the Qty Upd Flg check box is selected on the Shipping Excise Invoice page.
When you save the Shipping Excise Invoice page or click the Calculate Tax button, the tax determination and tax calculation processes apply the needed excise duty and sales tax to the shipping excise invoice. Use the excise duty to update the tax registers and create accounting entries in PeopleSoft Inventory. The sales tax on a shipping excise invoice passes to the sales order and then to PeopleSoft Billing, which creates the accounting entries.
Note. To cancel a shipping excise invoice that you have created, the status of the excise invoice must be New and the invoice cannot contain any shipping lines. If you cannot cancel the shipping excise invoice, then you must make an excise adjustment to reverse it.
Sample Sale
When issuing samples from the PeopleSoft Inventory unit located in India, often the material stock request (or sales order) does not contain a sales price. However, excise duty is still payable on samples shipped. To properly calculate excise duty, use the item’s assessable value as the base amount. Select the Use Assessable Value check box on the Tax Rate Code page to enable the system to find a base amount on the Item Defn Tax Applicability page or the Product Tax Applicability page.
Product KIT Sale
Excise duty is payable on the product kit and not on the individual components. Based on the tax structure, the excise duty is calculated on the kit’s sales price or the assessable value maintained on the Product Tax Applicability page. Before a product kit can be added to a shipping excise invoice, the system verifies that all kit components have been shipped in the proper quantities. The excise invoice displays all kit components and their related quantities. A product kit order cannot be shipped with multiple shipping ID’s.
Page Name |
Object Name |
Navigation |
Usage |
Inventory, Fulfill Stock Orders, Shipping Excise IND, Shipping Excise Invoice |
Add or update shipping excise invoices by adding order lines to this page. The system calculates the excise duty, and save the shipping excise invoice under a unique excise invoice number. Click the Print button to print the excise invoice. |
||
EXD_SHP_INV_SRCH |
Click the Add New Lines link on the Shipping Excise Invoice page. |
Use to select the shipping lines to add to the shipping excise invoice. |
|
RUN_INS6800 |
Inventory, Fulfill Stock Orders, Shipping Excise IND, Shipping Excise Invoice Report |
Prints a copy of the shipping excise invoice to accompany the item shipment from PeopleSoft Inventory. If more than one copy is printed, the subsequent copies are marked as duplicates. |
|
RUN_OM_EXS_APP_CHK |
Inventory, Fulfill Stock Orders,, Shipping Excise IND, Tax Applicability |
Run the Applicability Check process, which checks each ship line to determine if excise duties and sales taxes are applicable. Specify a business unit or all ship lines for all business units will be selected. |
See Also
(IND) Processing Customs, Excise Duties, and Sales Tax for India
Access the Shipping Excise Invoice page.
Excise Invoice Header
Unit |
Enter the PeopleSoft Inventory business unit that shipped the stock. |
Invoice (Excise Document Number) |
Displays the excise invoice number assigned to this shipping excise invoice. The number is from the Excise Document Number Series and the PeopleSoft Inventory business unit defined in the Unit field. The system validates the appropriate tax location for the unit to identify the format for the document number, such as prefix and length. If the Overwrite Allowed check box has been selected on the Excise Document Number Series page, then the user is allowed to add the invoice number. If the overwrite option has not been selected, the excise invoice number field displays NEXT until you save the shipping excise invoice. |
Date |
Displays the date this shipping excise invoice was created. When adding a new excise invoice, the system automatically uses the current system date. This value cannot be changed. |
Nbr Ser (excise document number series) |
Enter the excise document number series to be used to create a unique excise invoice number for this transaction. For shipping excise invoices, you are limited to the number series defined using one of the following excise transaction types: Domestic Sales, Export with Bond, Export without Bond, Deemed Export with Bond, Deemed Export, Manual, Inter-Unit Sale, or Stock Transfer. |
Ship To |
If the shipment was based on a sales order, this field displays the ship to customer ID from the shipping ID assigned to the sales order. If the shipment was based on an interunit transfer that crosses different tax locations but not different general ledger business units, then this field is unavailable. |
View Address |
Select to view the shipping address of the Ship To Customer ID. The address that appears (and used) is the address specified for the address sequence number selected, not any address overrides entered. |
The Rate Type, Currency Rt Divider, and Currency Rt Multiplier are from the sales order header linked to the shipping lines added to this excise invoice. If the excise invoice contains only interunit transfer shipments, nothing appears.
Add New Lines |
Click this link to access the Select Shipping Lines page, where you can search and select the shipping lines to be added to this shipping excise invoice. |
|
Click this button to print the completed shipping excise invoice. The invoice must have a status of Ready or Posted to be printed. |
Status |
Displays the status of the shipping excise invoice. Values are: N (new): The excise invoice has been entered and saved. The user can return to the Shipping Excise Invoice page and make further changes to the excise invoice. R (ready to post): The excise invoice has been entered and the user has manually changed the status to ready. The user can no longer make changes to the excise invoice. P(post): The excise invoice has completed the Excise Invoice Posting subprocess of the Register Update process. C (cancel): The excise invoice has been canceled. Canceled invoices are saved for audit purposes and to insure the invoice numbers are sequential. |
Excise Transaction Type |
Displays the type of transaction to be entered. For shipping excise invoices, the values are: Domestic Sales Export with Bond Export without Bond Deemed Export Deemed Export with Bond Manual Stock Transfer |
Quantity Update Flag |
Indicates the shipping excise invoice has completed the Excise Quantity Register Update subprocess of the Register Update process. |
Print Flag |
Indicates the shipping excise invoice has been printed. Any additional prints are identified as duplicates. |
Total Taxes
Tax information is summarized across all of the lines of this shipping excise invoice and the system displays the totals for excise tax, sales tax, and total tax (combined excise and sales tax).
Vehicle Information
Enter the required information about the shipment vehicle including vehicle number, lorry receipt number, and lorry receipt date.
Excise Invoice Lines
Displays the shipping lines added to this shipping excise invoice using the Select Shipping Lines page. The fields are populated from the shipping ID, sales order, or interunit transfer.
Src BU (source business unit) |
Displays the business unit that originated the order. For an interunit transfer it is the shipping PeopleSoft Inventory business unit and for a sales order it is the PeopleSoft Order Management business unit. |
Assessable Value |
The assessed per unit value of the item. This value appears by default from the Product Tax Applicability page or the Item Defn Tax Applicability page. |
Tax Transaction Type |
Defines the type of transaction. Values include: DEB (direct export with bond) DEWB (direct export without bond) DIMP (direct import) DOM (domestic) LEB (local export with bond) LEWB (local export without bond) LIMP (local import) |
Parent Product ID |
Displays the product kit ID if this line contains a product kit for PeopleSoft Order Management. |
EXD Rate Code |
Displays the tax rate code for excise duty. |
STX Rate Code |
Displays the tax rate code for sales tax. |
Tax Detail Lines
The bottom portion of this page displays the tax calculations for the excise invoice line. When you save the page or click the Calculate Tax button, the results of tax determination and tax calculations appear in this section.
Tax Type |
Displays the tax type that appears in this row. Values are: E (excise duty) or S (sales tax). |
Tax Cmpnt (tax component code) |
Displays codes established for each tax. |
Tax Dep Code (tax dependency code) |
Indicates the basis for calculating the tax, as well as the precedence of taxes of the same tax type that must be included. |
Calc Scheme (calculation scheme) |
Displays the default calculation scheme associated with the selected tax component code. You can override this value. Values are: A (amount): Ad hoc amount-based tax calculation. P (percentage): Percentage-based tax calculation. This is the default value. Q (quantity): Quantity-based tax calculation. |
Tax Rate Pct |
If the Calculation Scheme field value is set to Percentage, this field displays the percentage to be applied against the taxable amount. |
Tax Basis Amount |
If the Calculation Scheme field value is set to Percentage, this field displays the base value used for the tax calculations. |
Excise Curr Rptg (excise currency reporting) |
Displays the excise reporting currency that appears by default from the Tax Location page. |
Access the Excise Invoice Report page.
A printed copy of the excise invoice is required to accompany all shipments from Indian locations when excise duty is applicable. You can run this report by using the Print button on the Shipping Excise Invoice page or running this report process page. Once the excise invoice is printed, any reprints are identified as duplicates.
Enter the parameters to print one or more shipping excise invoices that have a status of Ready or Posted.
Unit |
Enter the PeopleSoft Inventory business unit for the shipping excise invoices to be printed. |
Invoice Option |
Indicates the shipping excise invoices to be printed. Values are: All Invoices Date of Invoice Range of Invoices Single Customer Single Invoice Single Location |
Date Invoice Created |
Enter the date of the shipping excise invoices that you wish to print. This field is available if you selected Date of Invoice for the invoice option. |
From Invoice Number and To Invoice Number |
Enter the range of the excise invoice numbers for the shipping excise invoices that you want to print. These fields are available if you selected Range of Invoices for the invoice option. |
Customer ID |
Enter the customer ID for the shipping excise invoices that you wish to print. This field is available if you selected Single Customer for the invoice option. |
Document Series |
Enter the document number series for the shipping excise invoice that you want to print. This field is available if you selected Single Invoice for the invoice option. |
Invoice Number |
Enter the excise invoice number for the shipping excise invoice that you want to print. This field is available if you selected Single Invoice for the invoice option. |
Reprint Invoice |
Select to print a second copy of the shipping excise invoice. The invoice is marked as a duplicate. This field is available if you selected Single Invoice for the invoice option. When this option is selected, only invoices that have been previously printed are available in the Invoice Number field. |
Location |
Enter the location code for the shipping excise invoices that you want to print. This field is available if you selected Single Location for the invoice option. |