Hi,

We had some issues in invoicing orders that are imported to adagio oe using the import utility/import orders. This problem occurs when we want to back order some items and shipped some items. Let's say we have 5 detail line items and we want to shipped the first 2 detail line and back order line 3,4, and 5. When we invoice this order, all the 5 items will be printed out with correct qty shipped (i.e line 3=0, line 4=0 and line 5=0) but the extended price of line 3,4, and 5 are not =0 but instead it is the product of unit price multiplied by the original qty ordered. As a result, the total invoice amout is wrong. One thing that I found out as I compared imported orders against orders actually entered manually to the system using Grid View, there is a field name "Overwrite Extended Price" and for orders that are manually entered the value of this field is false but for imported orders this field is always true. This field is not part of the OE Import Template field selection so there is no way we can force it to be false.

Pls let me know if there are work around to resolve this issue and by the way we are OE 8.0A.

Thanks,

Norman PAscua
CA Computer Systems
Los Angeles, CA 90025
Softrak Business Partner

Hello Norman,

I could not duplicate this behavior; when I print ?Invoices? using ?Print Invoices? only the detail lines that have shipped stock have an extended price.

On your specification, which specification code are you using to print the extended price?

Try printing your invoice using the sample specification OE$INVC1.SAM, Invoice: Formatted Address. This invoice specification uses D16, Extended selling price before discount amount, (invoice/credit note only).

Hi,
In order to duplicate this behavior, you need to import a new order with two or more detail lines. From the main menu click ORDERS icon and open the imported order and then go to the DETAIL SECTION. Try to shipped 1 item line (ex. Detail Line 1) and back order the rest of the line items then click OK button. A small screen will be displayed which allow you to select Invoice radio button and click OK button. The order will be Invoiced and take note of the generated Invoice #. You don't even need to send the invoice to the printer. Go to INVOICE section and open the generated Inv # and check the EXTENDED PRICE of the back ordered items. It should be zero but it is not in our case.

Thanks,

Norman Pascua
CA Computer Systems

Hi, Norman,

Thanks for the information. However, that is what we have already done. I'm thinking that the problem is not so much in the process (keystroke sequence) but in the spec itself.

Have you tried printing using the OE$INVC1.SAM, Invoice: Formatted Address?

There is a detail field called 'Extension Price'. Is this field included in your import? If it is then I believe this is the source of your problem.

Hi,

Yes!!! The extension price of the order is included in the import. I tried to remove the extension price,import the order and invoice just one dtl line and back ordered the rest gives me the correct invoice amount. Therefore, the extension price of the invoice does not automatically zero out for back ordered items. Is this correct?

Thanks for your help and great info.

Best Regards,

Norman

Typically in import, if you import a field, you want that value to over-ride any 'default' calculated amount. If you want the program to perform the calculation of the intended amount, don't import it. As Doug wrote, importing the Extension Price means you want to over-ride the calculated Extension Price based on Qty Shipped and Unit Price.