{"type":"doc","content":[{"type":"paragraph","content":[{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"excerpt-include","parameters":{"macroParams":{"":{"value":"FWINT HEAD"},"nopanel":{"value":"true"}},"macroMetadata":{"macroId":{"value":"ccf77aab-0a75-432e-a1ab-06f7ffed8262"},"schemaVersion":{"value":"1"},"title":"Excerpt Include"}},"localId":"49d5f4f9-1515-47aa-b227-0cfb304d2401"}},{"type":"hardBreak"},{"text":"Return to MYOB Accounts Receivable Integration","type":"text","marks":[{"type":"strong"},{"type":"link","attrs":{"href":"/wiki/spaces/FWECM/pages/2299988376"}}]},{"type":"hardBreak"},{"text":"Article Index","type":"text","marks":[{"type":"strong"}]}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"2ca272b5-5489-44a8-943a-9cec5126cfde"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"434b861b-3945-4eef-98f5-43eea38a24ca"}},{"type":"heading","attrs":{"level":2},"content":[{"text":"Integrated Fields","type":"text"}]},{"type":"paragraph","content":[{"text":"The integration of MYOB Accounts Receivable to Framework ECM is fixed in the content that is exchanged between the systems. There are no user-configurable integrated fields available for this type of integration.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Database Models","type":"text"}]},{"type":"paragraph","content":[{"text":"The following database model(s) displays the manner in which data is integrated between the third party application and Framework Integration.","type":"text"}]},{"type":"mediaSingle","attrs":{"layout":"align-start","width":23.0},"content":[{"type":"media","attrs":{"width":765,"id":"a1a587d7-a97d-42e1-be63-d972e577f61c","collection":"contentId-2299988458","type":"file","height":988}}]},{"type":"heading","attrs":{"level":2},"content":[{"type":"hardBreak"},{"text":"Integration Process","type":"text"}]},{"type":"paragraph","content":[{"text":"The following information is a low level account of the integration process including criteria, decisions, and outcomes. This information is technical in nature and is provided \"as-is\" for a detailed analysis of the integration process for system administrators.","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Read profile keys to determine which actions to process.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"ActionCreateInvoices","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Get eligible Framework jobs using v_FWINT_Invoices where","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"cst_claim.s_invoice_num > 0 and its length < 8 characters","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"cst_claim.s_link_accts <> ‘N/A’","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"cst_claim.f_link_exported <> -1","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"client.s_link_accts <> ‘N/A’","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Job. l_job_status_gl_id = -7 (Active) or -10 (On Hold) or l_job_status_gl_id = -946 (Pending Cancellation) or -8 (Cancelled) and d_cont_cancelled >= (today - 14 days)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"and apply Criteria Method criteria where CriteriaMethod is","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Single Region Division • job.l_context_id = ‘CriteriaMethodID’","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Single Job • job.s_job_num = ‘CriteriaMethodID’","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Single Team • job.l_team_id = ‘CriteriaMethodID’","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"All Jobs • job.l_job_id <> 0","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Accounts Entity • job.l_accounts_e_id = ‘CriteriaMethodID’","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The MYOB table Jobs is checked for a matching Job Number where Jobs.JobNumber = ‘job.s_link_boq’, or if the s_link_boq field is empty then the match is done on Jobs.JobNumber = ‘job.s_job_num’","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If the job is found then a new record is added to the temporary Import_Service_Sales table, from where MYOB Sales, SaleLines and ServiceSaleLines tables are updated via an internal MYOB process","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The Framework cst_claim is updated so that…","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"cstClaim.f_link_exported is set to true","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"cstClaim.s_link_accts is set to Sales.SaleID","type":"text"}]}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"ActionProcessReceipts","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Eligible receipts are read from MYOB Sales, SaleLines, CustomerPayments and CustomerPaymentLines tables where","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"if profile key DepositRunEndDate is empty then CustomerPayments.TransactionDate > = ‘DepositRunStartDate’ and <= now, else if DepositRunEndDate has a date entered then","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"CustomerPayments.TransactionDate > = ‘DepositRunStartDate’ and <= ‘DepositRunEndDate’","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Additionally, if Sales.TotalCredits > 0, then MYOB SettledCredits and SettledCreditLines tables are also read where","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"if profile key DepositRunEndDate is empty then SettledCredits.TransactionDate > = ‘DepositRunStartDate’ and <= now, else if DepositRunEndDate has a date entered then","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"SettledCredits.TransactionDate > = ‘DepositRunStartDate’ and <= ‘DepositRunEndDate’","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If MYOB record exists we","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Make sure the receipt does not exist in the cont_pay table where cont_pay.s_link_accts = CustomerPaymentLines. CustomerPaymentLineID (alternatively SettledCreditLines. SettledCreditLineID)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"if the payment does not exist then we can create it. First get the Framework job where job.s_job_num = SaleLines.JobID","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Then Insert the new cont_pay receipt record and update cst_claim.","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"After processing receipts the profile key depositRunStartDate is updated.","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"ActionCheckingConsistency","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Eligible Framework jobs for checking are retrieved from v_FWINT_ConsistencyByJob or v_FWINT_ConsistencyByInvoice, depending on profile setting, where","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If Check Consistency Level is claim by claim","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Job.l_wfl_stgMajor_id is checked against profile settings in the possible range of -5 to -2 (Pre-Administration, Administration, Construction, Maintenance)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Job. l_job_status_gl_id = -7 (Active) or -10 (On Hold) or l_job_status_gl_id = -946 (Pending Cancellation)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"job.s_link_accts <> ‘N/A’","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Cst_claim.s_invoice_num is not empty","type":"text"}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If Check Consistency Level is job by job","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Job.l_wfl_stgMajor_id is checked against profile settings in the possible range of -5 to -2 (Pre-Administration, Administration, Construction, Maintenance)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Job. l_job_status_gl_id = -7 (Active) or -10 (On Hold) ) or l_job_status_gl_id = -946 (Pending Cancellation)","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"job.s_link_accts <> ‘N/A’","type":"text"}]}]}]}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"apply Criteria Method criteria where CriteriaMethod is","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Single Region Division • job.l_context_id = ‘CriteriaMethodID’","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Single Job • job.s_job_num = ‘CriteriaMethodID’","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Single Team • job.l_team_id = ‘CriteriaMethodID’","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"All Jobs • job.l_job_id <> 0","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Accounts Entity • job.l_accounts_e_id =‘CriteriaMethodID’","type":"text"}]}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Invoice Totals are compared between MYOB and Framework:","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If Check Consistency Level is Claim by Claim","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Cst_claims with the same invoice numbers have their cst_claim.c_total field values summed together","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The matching invoice is retrieved from transactions where Sales.SaleID = cst_claim.s_link_accts","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If the invoice record is found the Sales.(TotalLines + TotalTax) is compared with the total of the cst_claim.c_total fields we calculated previously, to determine if the invoice totals match.","type":"text"}]}]}]}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If Check Consistency Level is Job by Job","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"All eligible claims for the job are read and the sum of cst_claim.c_total is determined","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The sum is compared to MYOB Sales.(TotalLines + TotalTax)","type":"text"}]}]}]}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Receipt Totals for each invoice or job are compared between MYOB and Framework","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If Check Consistency Level is Claim by Claim","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Cst_claims with the same invoice numbers have their cst_claim.c_paid_amt field values summed together","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The matching receipts are retrieved from transactions where Sales.SaleID = cst_claim.s_link_accts","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If there are receipts then the sum of Sales.(TotalPaid + TotalCredits) is calculated and compared with the total of the cst_claim.c_paid_amt fields we calculated previously, to determine if the receipts match.","type":"text"}]}]}]}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If Check Consistency Level is Job by Job","type":"text"}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The Framework Payments are summed together, the sum of c_pay from cont_pay is added up. Then because some cst_claims can indicate a refund we have to sum any cst_claims for the job where the c_paid_amt < 0 and remove this amount from the total payments.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"The matching receipts are retrieved from transactions where Sales.SaleID = cst_claim.s_link_accts","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"If there are receipts then the sum of Sales.(TotalPaid + TotalCredits) is calculated and compared with the total of the Framework payments, to determine if the receipts match.","type":"text"}]}]}]}]}]}]}]}]}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]}],"version":1}

Browser not supported