Hi, I made a script in Sales Order Entry that loops thru the lines and changes a few fields based on the previous lines (trying to group lines together for a report).
I'm getting an error now and after a lot of troubleshooting I realized that I only get the error when there is a price on the order. (if i put a zero item cost, the script runs fine) .
the script is a little hard to explain what I'm trying to do but I attached it, I get the error when the "retVal = oLines.Write()" runs.
I get an error 'SO_OpenOrderDetailByItem' does not have correct permissions' or some other random table name, but when looking in to the error I get "Error #13 File access mode invalid" "Program SY_SalesTaxCalculation_bus.pvc"
I have Administrative Rights
to me it seems like some tax calculation error but i'm not sure what i'm doing wrong if anyone can please help me i would greatly appreciate it
I attached the Code, Error Text, and the error messages
Error Information 08/29/22 11:34:12 Error #13: File access mode invalid Program SY_SalesTaxCalculation_bus.pvc Line 2507 General Information: File SO_OpenOrderDetailByItem Last Key Value Last Key Text Last Channel Opened 32483 Last Channel Accessed 0 Object Number 100045 Object Method BackoutLine Object Text SY_SalesTaxCalculation_bus Available Memory 20199189 Object Identifer Name --------------------------------------------- [100001] SY_Session [100002] SY_File [100003] SY_Crypto [100004] SY_Registration [100005] SY_UI [100006] SY_LocaleInfo [100007] SY_Security [100008] SY_Security [100009] SO_SalesOrder_UI [100010] SY_Security [100011] AR_Salesperson_svc [100012] SY_Collection [100013] SO_SalesOrder_Bus [100014] SY_Collection [100015] SY_ChildColl [100016] AR_PaymentType_Svc [100017] SY_ChildColl [100018] SY_ChildColl [100019] AR_Customer_svc [100020] SY_ChildColl [100021] SY_ChildColl [100022] SY_ChildColl [100023] SY_ChildColl [100024] SY_ChildColl [100025] SY_ChildColl [100026] SY_ChildColl [100027] SY_ChildColl [100028] SY_ChildColl [100029] SY_ChildColl [100030] SY_ChildColl [100031] SY_ChildColl [100032] SY_ChildColl [100033] SY_ChildColl [100034] SY_ChildColl [100035] SY_ChildColl [100036] SY_ChildColl [100037] SY_ChildColl [100038] SY_ChildColl [100039] SY_ChildColl [100040] SY_ChildColl [100041] SY_ChildColl [100042] SY_ChildColl [100043] SY_Script [100044] SY_User_svc [100045] SY_SalesTaxCalculation_bus [100046] SY_Collection [100047] SY_ChildColl [100048] SY_ChildColl [100049] SY_ChildColl [100050] SO_DuplicatePOChecking [100051] SO_ShipToAddress_svc [100052] SY_ZIPCode_svc [100053] SY_SalesTaxSchedZIPXref_svc [100054] AR_Customer_svc [100055] SO_SalesOrderPayment_bus [100056] SY_Collection [100057] SY_ChildColl [100058] AR_PaymentType_Svc [100059] SY_ChildColl [100060] SY_ChildColl [100061] SY_ChildColl [100062] SY_ChildColl [100063] SY_ChildColl [100064] SY_ChildColl [100065] SY_ChildColl [100066] AR_Customer_svc [100067] SY_ChildColl [100068] AR_Customer_svc [100069] SY_SalesTaxCalculation_bus [100070] SY_Collection [100071] SY_ChildColl [100072] SY_ChildColl [100073] SY_ChildColl [100074] SO_Options_Svc [100075] SO_ShippingOptions_svc [100076] AR_Options_Svc [100077] SO_SalesOrderDetail_Bus [100078] SY_Collection [100079] SY_ChildColl [100080] SY_ChildColl [100081] SY_ChildColl [100082] SY_ChildColl [100083] SY_ChildColl [100084] SY_Script [100085] SO_SalesOrderTierDistribution_bus [100086] SY_Collection [100087] SY_ChildColl [100088] SY_ChildColl [100089] SY_ChildColl [100090] IM_ItemCost_svc [100091] CI_ItemCode_svc [100092] IM_Warehouse_svc [100093] CI_ExtendedDescription_bus [100094] CI_ItemCode_svc [100095] CI_ItemCode_svc [100096] IM_Warehouse_svc [100097] SY_ChildColl [100098] SY_ChildColl [100099] SY_ChildColl [100100] SY_ChildColl [100101] SY_ChildColl [100102] SY_ChildColl [100103] SY_ChildColl [100104] SY_ChildColl [100105] SY_ChildColl [100106] SY_ChildColl [100107] SY_ChildColl [100108] SY_ChildColl [100109] SY_ChildColl [100110] SY_ChildColl [100111] IM_ProductLine_svc [100112] SO_SalesOrderDefaults_Svc [100113] SY_ChildColl [100114] SY_MemoFlow_Bus [100115] SY_Collection [100116] SY_ChildColl [100117] SY_ChildColl [100118] SY_ChildColl [100119] SY_MemoManager_Svc [100120] GL_CompanyMemoManagerSettings_Svc [100121] SY_BusinessColl [100122] SY_BusinessColl [100123] SY_BusinessColl [100124] SY_BusinessColl [100125] GL_Account_svc [100126] CM_Customizer_Svc [100127] *obj/folder [100128] *obj/group [100129] *obj/tab [100130] *obj/tab [100131] *obj/tab [100132] *obj/tab [100133] *obj/tab [100134] SY_MemoHandler_UI [100135] SY_Collection [100136] SY_MemoHandler_Bus [100137] SY_Collection [100138] SY_ChildColl [100139] SY_ChildColl [100140] SY_ChildColl [100141] SY_MemoManager_Svc [100142] GL_CompanyMemoManagerSettings_Svc [100143] SY_BusinessColl [100144] SY_Module_svc [100145] SY_User_svc [100146] AR_TermsCode_Svc [100147] IM_Warehouse_svc [100148] AR_Salesperson_svc [100149] SY_SalesTaxSchedule_Svc [100150] AR_Division_svc [100151] SO_ShippingRate_svc [100152] SY_Script [100153] AP_Vendor_svc [100154] Sy_PopupXref_Svc [100155] IM_Warehouse_svc [100156] SY_ErrorInfo_UI [100157] SY_Collection [100158] SY_ErrorInfo_BUS [100159] SY_BusinessColl [100160] *obj/folder [100161] *obj/group [100162] *obj/tab [100163] *obj/tab [100164] *obj/tab [100165] *obj/tab Open Files: Channel File Name --------------------------------------------- 32477 *memory* 32478 *memory* 32479 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_ActivityLog.M4T 32480 *memory* 32481 *memory* 32482 *memory* 32483 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_OpenOrderDetailByItem.M4T 32484 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\IMOEG\IM_ItemWarehouse.M4T 32485 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\CI_Item.LCK 32486 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\CIOEG\CI_Item.M4T 32487 *memory* 32488 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\IMOEG\IM_Warehouse.M4T 32489 *memory* 32490 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\AR_Customer.LCK 32491 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_Customer.M4T 32492 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderPrint.M4T 32493 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\SO_InvoiceHeader.LCK 32494 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_InvoiceHeader.M4T 32495 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderHistoryHeader.M4T 32496 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\SO_SalesOrderHeader.LCK 32497 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderHeader.M4T 32498 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_InvoiceHistoryHeader.M4T 32499 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_InvoiceHeader.M4T 32500 *memory* 32501 *memory* 32502 *memory* 32503 *memory* 32504 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_PopupXref.M4T 32505 *memory* 32506 *memory* 32507 *memory* 32508 *memory* 32509 *memory* 32510 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\AP_Vendor.LCK 32511 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\APOEG\AP_Vendor.M4T 32512 *memory* 32513 *memory* 32514 *memory* 32515 *memory* 32516 *memory* 32517 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_GridDefinition.M4T 32518 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_CustomerMemoSettings.M4T 32519 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_CustomerMemo.M4T 32520 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderMemoSettings.M4T 32521 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderMemo.M4T 32522 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_ShippingRateDetail.M4T 32523 *memory* 32524 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_ShippingRateHeader.M4T 32525 *memory* 32526 *memory* 32527 *memory* 32528 *memory* 32529 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_Division.M4T 32530 *memory* 32531 *memory* 32532 *memory* 32533 *memory* 32534 *memory* 32535 *memory* 32536 *memory* 32537 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderTaxSummary.M4T 32538 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderHistoryTaxSummary.M4T 32539 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderHistoryTaxDetail.M4T 32540 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderRecap.M4T 32541 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderHistoryPayment.M4T 32542 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderTaxSummary.M4T 32543 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderHistoryTaxSummary.M4T 32544 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderTaxSummary.M4T 32545 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderTaxDetail.M4T 32546 *memory* 32547 *memory* 32548 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_SalesTaxSchedule.M4T 32549 *memory* 32550 *memory* 32551 *memory* 32552 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_Salesperson.M4T 32553 *memory* 32554 *memory* 32555 *memory* 32556 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\IMOEG\IM_Warehouse.M4T 32557 *memory* 32558 *memory* 32559 *memory* 32560 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_TermsCode.M4T 32561 *memory* 32562 *memory* 32563 *memory* 32564 *memory* 32565 *memory* 32566 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_User.M4T 32567 *memory* 32568 *memory* 32569 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_Module.M4T 32570 *memory* 32571 *memory* 32572 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\GLOEG\GL_CompanyMemoManagerSettings.M4T 32573 *memory* 32574 *memory* 32575 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_MemoManager.M4T 32576 *memory* 32577 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\GLOEG\GL_CompanyMemoManagerSettings.M4T 32578 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_MemoDefault.M4T 32579 *memory* 32580 *memory* 32581 *memory* 32582 *memory* 32583 *memory* 32584 *memory* 32585 *memory* 32586 *memory* 32587 *memory* 32588 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_Module.M4T 32589 \\server\90w\Sage\Sage2013\MAS90\SOA\SY0CTL.SOA 32590 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_UDT_ECLIPSE_ORDER_LOG.M4T 32591 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\IMOEG\IM_UDT_ECLIPSE_ITEM_LENGTH.M4T 32592 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\IMOEG\IM_UDT_ECLIPSE_STOCK_ITEM_LEN.M4T 32593 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\BMOEG\BM_BillDetail.M4T 32594 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\BM_BillHeader.LCK 32595 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\BMOEG\BM_BillHeader.M4T 32596 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderDetail.M4T 32597 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\SO_SalesOrderHeader.LCK 32598 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderHeader.M4T 32599 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\CIOEG\CI_ExtendedDescription.M4T 32600 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\CI_Item.LCK 32601 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\CIOEG\CI_Item.M4T 32602 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\AR_Customer.LCK 32603 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_Customer.M4T 32604 *memory* 32605 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\GL_Account.LCK 32606 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\GLOEG\GL_Account.M4T 32607 *memory* 32608 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SCOEG\SC_ShippingStatus.M4T 32609 *memory* 32610 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\GLOEG\GL_CompanyMemoManagerSettings.M4T 32611 *memory* 32612 *memory* 32613 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_MemoManager.M4T 32614 *memory* 32615 *memory* 32616 *memory* 32617 *memory* 32618 *memory* 32619 *memory* 32620 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderDefaults.M4T 32621 *memory* 32622 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_UDT_COMPONENT_SHORT_WARNING.M4T 32623 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\IMOEG\IM_ItemWarehouse.M4T 32624 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\SO_SalesOrderHeader.LCK 32625 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderHeader.M4T 32626 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderDetail.M4T 32627 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\BMOEG\BM_BillDetail.M4T 32628 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\BMOEG\BM_BillDetail.M4T 32629 *memory* 32630 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\IMOEG\IM_ProductLine.M4T 32631 *memory* 32632 *memory* 32633 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\IMOEG\IM_Warehouse.M4T 32634 *memory* 32635 *memory* 32636 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\CI_Item.LCK 32637 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\CIOEG\CI_Item.M4T 32638 *memory* 32639 *memory* 32640 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\CI_Item.LCK 32641 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\CIOEG\CI_Item.M4T 32642 *memory* 32643 *memory* 32644 *memory* 32645 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\CIOEG\CI_ExtendedDescription.M4T 32646 *memory* 32647 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderTierDistribution.M4T 32648 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderDetail.M4T 32649 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderTierDistribution.M4T 32650 *memory* 32651 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\IMOEG\IM_Warehouse.M4T 32652 *memory* 32653 *memory* 32654 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\CI_Item.LCK 32655 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\CIOEG\CI_Item.M4T 32656 *memory* 32657 *memory* 32658 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\IMOEG\IM_ItemCost.M4T 32659 *memory* 32660 *memory* 32661 *memory* 32662 *memory* 32663 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderTierDistribution.M4T 32664 *memory* 32665 *memory* 32666 *memory* 32667 *memory* 32668 *memory* 32669 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderDetail.M4T 32670 *memory* 32671 *memory* 32672 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_Options.M4T 32673 *memory* 32674 *memory* 32675 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_ShippingOptions.M4T 32676 *memory* 32677 *memory* 32678 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_Options.M4T 32679 *memory* 32680 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_CustomerShipToTaxExemptions.M4T 32681 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_SalesTaxCodeDetail.M4T 32682 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_SalesTaxCode.M4T 32683 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_SalesTaxScheduleDetail.M4T 32684 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_SalesTaxScheduleDetail.M4T 32685 *memory* 32686 *memory* 32687 *memory* 32688 *memory* 32689 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderHistoryPayment.M4T 32690 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderHistoryDetail.M4T 32691 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderHistoryHeader.M4T 32692 *memory* 32693 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\AR_Customer.LCK 32694 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_Customer.M4T 32695 *memory* 32696 *memory* 32697 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\AR_Customer.LCK 32698 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_Customer.M4T 32699 *memory* 32700 *memory* 32701 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_PaymentType.M4T 32702 *memory* 32703 *memory* 32704 *memory* 32705 *memory* 32706 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderPayment.M4T 32707 *memory* 32708 *memory* 32709 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\AR_Customer.LCK 32710 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_Customer.M4T 32711 *memory* 32712 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_SalesTaxScheduleStateXref.M4T 32713 *memory* 32714 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_SalesTaxScheduleZIPXref.M4T 32715 *memory* 32716 *memory* 32717 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_ZIPCode.M4T 32718 *memory* 32719 *memory* 32720 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_ShipToAddress.M4T 32721 *memory* 32722 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_CustomerShipToTaxExemptions.M4T 32723 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_SalesTaxCodeDetail.M4T 32724 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_SalesTaxCode.M4T 32725 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_SalesTaxScheduleDetail.M4T 32726 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_SalesTaxScheduleDetail.M4T 32727 *memory* 32728 *memory* 32729 *memory* 32730 *memory* 32731 *memory* 32732 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_User.M4T 32733 *memory* 32734 *memory* 32735 *memory* 32736 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\AR_Customer.LCK 32737 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_Customer.M4T 32738 *memory* 32739 *memory* 32740 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_PaymentType.M4T 32741 *memory* 32742 *memory* 32743 *memory* 32744 *memory* 32745 \\server\90w\Sage\Sage2013\MAS90\LOCK\_OEG\SO_SalesOrderHeader.LCK 32746 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\SOOEG\SO_SalesOrderHeader.M4T 32747 *memory* 32748 *memory* 32749 \\server\90w\Sage\Sage2013\MAS90\MAS_OEG\AROEG\AR_Salesperson.M4T 32750 *memory* 32751 *memory* 32752 *memory* 32753 *memory* 32754 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_RoleSecurity.M4T 32755 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_UserSecurity.M4T 32756 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_User.M4T 32757 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_Task.M4T 32758 *memory* 32759 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_RoleSecurity.M4T 32760 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_UserSecurity.M4T 32761 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_User.M4T 32762 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_Task.M4T 32763 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_RoleSecurity.M4T 32764 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_UserSecurity.M4T 32765 \\server\90w\Sage\Sage2013\MAS90\MAS_SYSTEM\SY_Task.M4T 32766 \\server\90w\Sage\Sage2013\MAS90\providex.dde 32767 \\server\90w\Sage\Sage2013\MAS90\providex.ddf Stack Line Program ---------------------------------------------------------------------------------------------------- 00030 00001 \\server\90w\Sage\Sage2013\MAS90\SY\SY_ErrorInfo_ui.pvc 00029 00290 \\server\90w\Sage\Sage2013\MAS90\SY\SY_ErrorInfo_ui.pvc 00028 00040 \\server\90w\Sage\Sage2013\MAS90\Home\lib\_winproc.xeq 00027 07120 \\server\90w\Sage\Sage2013\MAS90\Home\lib\_winproc 00026 00550 \\server\90w\Sage\Sage2013\MAS90\Home\lib\_nomads.pvc 00025 00447 \\server\90w\Sage\Sage2013\MAS90\SY\SY_ERROR 00024 02507 \\server\90w\Sage\Sage2013\MAS90\SY\SY_SalesTaxCalculation_bus.pvc 00023 00624 \\server\90w\Sage\Sage2013\MAS90\SO\SO_SalesOrderDetail_Bus.pvc 00022 00997 \\server\90w\Sage\Sage2013\MAS90\SY\SY_LineEntryDetail_bus.pvc 00021 00325 \\server\90w\Sage\Sage2013\MAS90\SY\SY_LineEntryTierDetail.pvc 00020 01478 \\server\90w\Sage\Sage2013\MAS90\SO\SO_CommonEntryDetail.pvc 00019 00445 \\server\90w\Sage\Sage2013\MAS90\SY\SY_Maint.pvc 00018 01175 \\server\90w\Sage\Sage2013\MAS90\SY\SY_LineEntryDetail_bus.pvc 00017 00491 \\server\90w\Sage\Sage2013\MAS90\SY\SY_LineEntryTierDetail.pvc 00016 03613 \\server\90w\Sage\Sage2013\MAS90\SO\SO_CommonEntryDetail.pvc 00015 03039 \\server\90w\Sage\Sage2013\MAS90\SY\SY_Maint.pvc 00014 00465 \\server\90w\Sage\Sage2013\MAS90\SY\SY_Maint.pvc 00013 00201 \\server\90w\Sage\Sage2013\MAS90\SY\SY_LineEntryHeader_Bus.pvc 00012 04285 \\server\90w\Sage\Sage2013\MAS90\SO\SO_SalesOrder_Bus.pvc 00011 00242 \\server\90w\Sage\Sage2013\MAS90\SY\SY_MaintUI.pvc 00010 00931 \\server\90w\Sage\Sage2013\MAS90\SO\SO_CommonEntry_UI.pvc 00009 00491 \\server\90w\Sage\Sage2013\MAS90\SO\SO_SALESORDER_UI.pvc 00008 00034 \\server\90w\Sage\Sage2013\MAS90\SO\SO_SALESORDER_UI_519SC.pvc 00007 00179 \\server\90w\Sage\Sage2013\MAS90\SO\SO_492_SALESORDER_UI.pvc 00006 00209 \\server\90w\Sage\Sage2013\MAS90\SO\SO_492BOI_SALESORDER_UI.pvc 00005 00040 \\server\90w\Sage\Sage2013\MAS90\Home\lib\_winproc.xeq 00004 07120 \\server\90w\Sage\Sage2013\MAS90\Home\lib\_winproc 00003 00550 \\server\90w\Sage\Sage2013\MAS90\Home\lib\_nomads.pvc 00002 00401 \\server\90w\Sage\Sage2013\MAS90\SY\SY_LineEntry_ui.pvc 00001 00285 \\server\90w\Sage\Sage2013\MAS90\soa\SY_StartUp.M4P
IF oSession.UserCode = "ASF" Then
IF CBool(oScript.UIObj) = "True" And oSession.Updating = 0 Then
xCompany = oSession.CompanyCode
IF (xCompany="xxx") or (xCompany="TST") Then
'Declare Variables
'sGroupLineNumber is used for grouping
'sConfLineNum is used for the line number on the confirmation
'sConfItemCode is used to bundle together stock item codes and standard item codes
'every variable starts with an s regardless if it's a string
sItemCode = ""
sComment = ""
sFeet = 0
sInches = 0
sPrice = 0
sRealLineNumber = ""
sGroupLineNumber = ""
sConfLineNum = ""
sConfItemCode = ""
sUnique = ""
sPrevious = ""
x = 0
'Start Loop
Set oLines = oBusObj.AsObject(oBusObj.Lines)
retVal = oLines.MoveFirst()
Do Until CBool(oLines.EOF)
'Get all needed Values
retVal = oLines.GetValue("ItemCode$",sItemCode)
retVal = oLines.GetValue("CommentText$",sComment)
retVal = oLines.GetValue("UDF_FEET",sFeet)
retVal = oLines.GetValue("UDF_INCHES",sInches)
retVal = oLines.GetValue("UnitPrice",sPrice)
retVal = oLines.GetValue("LineKey$",sRealLineNumber)
'convert line number to integar
sRealLineNumber = CDbl(sRealLineNumber)
'strip stock charachters from item code
sConfItemCode = sItemCode
If (Right(sConfItemCode, 3) = "-10") Or (Right(sConfItemCode, 3) = "-12") Or (Right(sConfItemCode, 2) = "8") Then
sConfItemCode = Left(sConfItemCode, InStr(sConfItemCode, "-") - 1)
End if
MsgBox sRealLineNumber
'create unique for group
sUnique = sConfItemCode & sComment & sFeet & sInches & sPrice
'IF x >0 Then
'if statement to see if line number is grouped with the previous line
IF sUnique = sPrevious Then
'create group line number and confirmation line number
sGroupLineNumber = sRealLineNumber - 1 & " "
sConfLineNum = sGroupLineNumber & "& " & sRealLineNumber
' write the three new data fields
retVal = oLines.SetValue("UDF_CONF_GROUPNO$", sGroupLineNumber)
retVal = oLines.SetValue("UDF_CONF_LINENO$", sConfLineNum)
retVal = oLines.SetValue("UDF_CONF_ITEM$", sConfItemCode)
retVal = oLines.Write() 'Save detail line
Else
sGroupLineNumber = sRealLineNumber & " "
retVal = oLines.SetValue("UDF_CONF_GROUPNO$", sGroupLineNumber)
retVal = oLines.SetValue("UDF_CONF_LINENO$", sGroupLineNumber)
retVal = oLines.SetValue("UDF_CONF_ITEM$", sConfItemCode)
retVal = oLines.Write()
End IF
MsgBox "hi"
x = x + 1
sPrevious = sUnique
retVal3 = oLines.MoveNext()
Loop
MsgBox "bYE"
End IF
End IF
End IF
