SO_InvoiceDetail

Class SO_InvoiceDetail_Bus

Inherits

CI_ItemWarehouse, SO_CommonEntryDetail, SY_Customization, SY_SalesTaxClass_val

Properties

LOCAL cCommentValidated=isFALSE

LOCAL cFromQtyOrdered=isFALSE

LOCAL cFromInvoice=isFALSE

LOCAL cFromShipping=isFALSE

LOCAL cMainTable$="SO_InvoiceDetail"

LOCAL cIsSysDB=isFALSE

LOCAL cInvoiceTypeCM$="CM"

String constant for credit memo invoice type

LOCAL cDistDstIOList$=CPL("IOLIST InvoiceNo$, LineKey$, OrderLineKey$, ItemCode$, WarehouseCode$, QuantityShipped, "+"QuantityOrdered, Valuation$, UnitOfMeasureConvFactor, SalesOrderNo$, cLotSerRefDate$, cLotSerTransType")

LOCAL cDistSrcIOList$=CPL("IOLIST InvoiceNo$, LineKey$, OrderLineKey$, ItemCode$, WarehouseCode$, QuantityShipped, "+"QuantityOrdered, Valuation$, UnitOfMeasureConvFactor, cSalesOrderNo$, TBL(header.InvoiceType$=cInvoiceTypeCM$, "+"header.ShipDate$, header.InvoiceDate$), TBL(header.InvoiceType$=cInvoiceTypeCM$, lsTransSALE, lsTransRETURN)")

LOCAL cDistObject$="SO_InvoiceTierDistribution_bus"

LOCAL cDistQtyVar$="QuantityShipped"

LOCAL cItmCommonFields$="InvoiceNo$, LineKey$, LineSeqNo$, SalesKitLineKey$, ItemCode$, "+"ItemType$, rowStatus$, OrderLineKey$, OrderWarehouse$"

PROPERTY AllLinesBackordered

PROPERTY AlternateItem

PROPERTY AppliedSalesOrderNos$

[string] a list of sales order numbers that have been applied to this invoice

PROPERTY cMemoryFile

PROPERTY LinesChangedInShipping$

PROPERTY PackageNo$

PROPERTY BinLocation$

PROPERTY CopyFromSODtlSrc$ * Read Only *

PROPERTY CopyFromSODtlDest$ * Read Only *

PROPERTY ShippableLines * Read Only *

[numeric] Number of sales order lines shippable through Shipping Date Entry

PROPERTY RefreshCustomerPONo

[booleon] When true (1), identifies when a change to AppliedCustomerPONo$ has occurred, used to trigger a primary grid refresh (when needed)

Methods

FUNCTION AllLinesComplete(key$, rowNo, SO_LineKey$)

FUNCTION AllShipped()

FUNCTION AllShipped(value)

FUNCTION AssignAccounts(itemType$)

FUNCTION BackOrder()

FUNCTION BackOrder(value)

FUNCTION CheckForAliasItem(alias$, item$)

FUNCTION CheckForMissingJobInfo()

FUNCTION CheckForPriceLevelByShipTo(oldCode$, newCode$)

FUNCTION ClearSetFiles()

FUNCTION CommitRow()

FUNCTION CopyLinesFromSalesOrder(value$)

FUNCTION CopyLinesFromSalesOrder(value$, complete$)

FUNCTION CreditMemoCopyLinesFromInvoiceHistory(tmpInvoiceNo$, tmpHeaderSeqNo$, tmpUseCostFromHistory$, tmpUseGLFromHistory$)

Credit Memo Copy Lines From Invoice History

Parameter	Description
tmpInvoiceNo$	[input,string] invoice number to copy from
tmpHeaderSeqNo$	[input,string] header sequence number of history record to copy from
tmpUseCostFromHistory$	[input,string] use cost from history invoice lines in credit memo lines Y or N?
tmpUseGLFromHistory$	[input,string] use GL Account from history othewise use Sales Return Account (Y/N)

Returns

[boolean] True = copy lines from history is successful, False = copy failed

FUNCTION CurrentQtyToBackOut()

FUNCTION DeleteLine()

FUNCTION DeleteLine(LineKey$)

FUNCTION EditLine(LineKey$)

FUNCTION FindItemCodeInMemFile(Inv$, LKey$, ItmCd$, whscd$)

FUNCTION FromInvoice(value)

FUNCTION FromShipping()

FUNCTION GetBatchTotalVars(vars$)

FUNCTION GetBatchTotalVars(vars$, reverse)

FUNCTION GetContext$(destTable$)

Get the contexts available for a table

Parameter	Description
destTable$	[input,string] table name

Returns

[string] all contexts available for a given table

FUNCTION GetContextSourceTables$(context$)

Get the source table for a context

Parameter	Description
context$	[input,string] context

Returns

[string] source table for a given context

FUNCTION GetDetailQtyForAvailableQtyCalc()

Get Detail records Quantity for the Available Quantity Calculation. Used for UI class to determine if quantity should be highlighted in red.

Returns

[numeric] Quantity for detail record used in Available Quantity Calculation

FUNCTION GetFieldInfo(key$, Col$, Var$)

FUNCTION GetFieldInfo(key$, Col$, Var$, fromDeleteFh)

FUNCTION GetParentCustomerPONo(parentKy$, parentCustPONo$)

Retrieves the applied customer PO number from a kit parent lineKey

Parameter	Description
parentKy$	[input, string] value of SalesLineKey$ on component line that points to the kit parent detail line
parentCustPONo$	[output, string] AppliedCustomerPONo$ for the parent detail line

Returns

[boolean] Success or Failure

FUNCTION GetQuantities(key$, Qo, Qs)

FUNCTION GetQuantityOrdered(InvoiceNo$, ItemCode$)

FUNCTION GetQuantityShipped(InvoiceNo$, ItemCode$)

FUNCTION GetQuantityShipped(InvoiceNo$, ItemCode$, excludeNegativeQty, excludeDropShip)

FUNCTION InitWorkTable()

FUNCTION ResetRow(lineKey$)

FUNCTION ResetRowsWithDistribution()

FUNCTION ResetSalesOrderRow()

FUNCTION ResetSalesOrderRow(lineKey$)

FUNCTION ResetSalesOrderRow(lineKey$, complete$)

FUNCTION RetrieveAllSalesOrderLines()

FUNCTION RetrieveDeletedSalesOrderLines()

FUNCTION RetrieveSalesOrderLine()

FUNCTION RetrieveSalesOrderLine(value)

FUNCTION RetrieveSalesOrderLine(value, complete$)

FUNCTION SetBalance(value)

FUNCTION SetClearCostCode(value)

FUNCTION SetExpirationDate()

FUNCTION SetHeader(header$)

FUNCTION SetOrderType()

FUNCTION SetQuantityBackOrdered(value)

FUNCTION ShipRemaining()

FUNCTION ShipRemaining(tmpSalesOrderNo$)

Sets Quantity Shipped to Quantity Ordered - Quantity Backordered on any line that is not fully shipped and/or backordered

Parameter	Description
tmpSalesOrderNo$	{optional} [input, string] sales order number to ship remaining for (used for multiple s/o on 1 invoice)

Returns

[boolean] Success or Failure

FUNCTION SkipLineValidation()

FUNCTION ValidateLines()

Properties inherited from: CI_ItemWarehouse

cPrecisionQty, IM_IsSetup

Properties inherited from: SO_CommonEntryDetail

cDistAutoAdjusted, cItemChanged, cKitChanged, cKitUOMChanged, cKitUpdateUOMOnly, cQtyDigits, AP_Divisions$, Balance, ComponentLine, CostMask$, CreateFromRMA, ItemValuation$, KitLine, PriceMask$, QtyMask$, UnitOfMeasures$, ExtensionQtyCol$, PriceLevelByCustSvc, coSO_PurchaseControl

Properties inherited from: SY_Customization

cDummyIol$

Methods inherited from: CI_ItemWarehouse

CommitQuantity()

Methods inherited from: SO_CommonEntryDetail

AddIn(), AllLinesComplete(), AssignAccounts(), BackOut(), CalculateProfitMargin(), CalculateQtyAvailable(), CheckForMissingJobInfo(), CheckForPurchaseControlRecords(), ClearInvalidPurchaseItems(), ClearJobInfo(), ClearSetFiles(), CurrentQtyToBackOut(), DefaultPriceLevel$(), DeleteAllLines(), DeleteComponentLines(), DeleteLine(), DistributionAutoAdjusted(), DistributionRequired(), FindKitCount(), GetHeaderFields(), GetItemCosts(), GetItemWhs(), IsExplodedKitLine(), RecalculateLinePricing(), RemoveJobInfo(), ResetLine(), SetDefaultDate(), SetHeader(), SetHeaderInfo(), SetJobInfo(), SetUnitOfMeasures(), SkipLineValidation(), UpdateJobAccounts(), ValidateGroupARSalesTax(), ValidateGroupBMIntegrated(), ValidateGroupBMUseRevisions(), ValidateGroupCCLevel3Dtl(), ValidateGroupIMIntegrated(), ValidateGroupItemRequired(), ValidateGroupItemTypes(), ValidateGroupJCIntegrated(), ValidateGroupLineDiscount(), ValidateGroupMultiWarehouse(), ValidateGroupNotCharge(), ValidateGroupNotComment(), ValidateGroupNotComponent(), ValidateGroupNotNulWarehouseCode(), ValidateGroupPOSetup(), ValidateGroupPostJCCosts(), ValidateGroupRMAOrder(), ValidateGroupSalespersonReporting(), ValidateGroupUseOptionBills(), ValidateGroupVendorDisplay(), ValidateGroupWarrantyTracking(), ValidateLines(), WRITE(), CalculateCost(), CalculatePrice(), CheckDistribution(), CheckForAlias(), ClassValidateBillOption(), ClearSetFilesAdjustIMForJC(), ColumnOverrideBillOption1(), ColumnOverrideBillOption2(), ColumnOverrideBillOption3(), ColumnOverrideBillOption4(), ColumnOverrideBillOption5(), ColumnOverrideBillOption6(), ColumnOverrideBillOption7(), ColumnOverrideBillOption8(), ColumnOverrideBillOption9(), ColumnOverrideCostCode(), ColumnOverrideCostType(), ColumnOverrideMasterOriginalQty(), ColumnOverrideMasterQtyBalance(), ColumnOverrideMasterQtyOrderedToDate(), ColumnOverrideQuantityBackOrdered(), ColumnOverrideQuantityOrdered(), ColumnOverrideQuantityPerBill(), ColumnOverrideQuantityShipped(), ColumnOverrideRepeatingQtyShippedToDate(), ColumnOverrideUnitCost(), ColumnOverrideUnitPrice(), ColumnOverrideWarrantyCode(), CommitRowWrite(), DeleteComponentLine(), FindKitLine(), GenerateFormatMask$(), GetAccountsFromJob(), GetPriceRecord(), GetWarehouseQty(), IsJobInfoValid(), LocalizeIOLIST(), PostWriteRec(), ProgressMeter(), ResetRowAmounts(), RetrieveWeight(), ReturnUDFs(), SaveRowAmounts(), SetCurrentKey(), SetDefaultAccounts(), SetDefaults(), SetKey(), SetKitComponentFromParentColumns(), SetKitComponentLineColumns(), UpdateCustomerLastPurchHistory(), UpdateKitComponentLineColumns(), UpdateKitLines(), ValidateAPDivisionNo(), ValidateCostCode(), ValidateCostOfGoodsSoldAcctKey(), ValidateCostType(), ValidateDropShip(), ValidateExplodedKitItem$(), ValidateItemCode(), ValidateLineDiscountPercent(), ValidatePriceLevel(), ValidatePromiseDate(), ValidateQuantityOrdered(), ValidateQuantityShipped(), ValidateSalesAcctKey(), ValidateTaxClass(), ValidateUnitCost(), ValidateUnitOfMeasure(), ValidateUnitPrice(), ValidateVendorNo(), ValidateWarehouseCode(), ValidateWarrantyCode(), WriteLineUpdateKitLines()

Methods inherited from: SY_Customization

GetCustomizations(), PostTableRead(), PreNextRecord(), PreTableWrite()

Methods inherited from: SY_SalesTaxClass_val

ClassValidateTaxClass()