the sales collection business process n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
The Sales/Collection Business Process PowerPoint Presentation
Download Presentation
The Sales/Collection Business Process

Loading in 2 Seconds...

play fullscreen
1 / 29

The Sales/Collection Business Process - PowerPoint PPT Presentation


  • 144 Views
  • Uploaded on

The Sales/Collection Business Process. Accounts Receivable Query Join & Null to Zero (NZ) considerations. Summary Accounts Receivable Query Steps. Practically Total sales/service engagements through balance sheet date on account

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

The Sales/Collection Business Process


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
    Presentation Transcript
    the sales collection business process

    The Sales/Collection Business Process

    Accounts Receivable QueryJoin & Null to Zero (NZ) considerations

    summary accounts receivable query steps
    Summary Accounts Receivable Query Steps
    • Practically
      • Total sales/service engagements through balance sheet date on account
      • minus total cash receipts through balance sheet date that applied to sales/service engagements on account.
      • Also subtract sales returns and discounts through balance sheet date.
      • Use cash receipt date and duality relationship to determine which cash receipts to include. Be sure to aggregate cash receipts that apply to same sale BEFORE subtracting from sale amount
      • Likely need for Outer Join and NZ function in Access (for sales with no matching cash receipts
      • Note: Sales minus Cash receipts from Customers may not be acceptable (because you might get non-sale related CR from customers)
    slide3

    Customer table

    Cash receipts table

    Sale table

    Sale Inventory table

    Sale Return table

    summary accounts receivable query
    Summary Accounts Receivable Query
    • Data sources
      • Sales table
        • Date and summary cash sales data
        • Note if summary cash sales data not stored, it would be necessary to calculate sales figure pulling data from the sales –inventory table
      • Cash receipts table
      • Sales return table
    summary accounts receivable step 1 total sales through balance sheet date
    Summary Accounts Receivable Step 1: Total Sales through Balance Sheet Date
    • For repetitive queries requiring date criteria, date parameter should be used instead of hard coding date criteria.

    date as parameter<=[bsdate]

    slide7

    Summary Accounts Receivable Step 2: Total Cash Receipts related to Sales through Balance Sheet Date

    2a: identify them

    2b: sum them

    slide8

    Summary Accounts Receivable Step 3:Total Sale Returns through Balance Sheet Date

    Identify and sum them

    slide9

    Summary Accounts Receivable Step 4: Calculate A/R as sales minus applicable cash receipts and sale returns

    AcctsReceivable: [sales total]-[cash receipts]-[returns]

    accounts receivable result without nz
    Accounts Receivable Result without Nz

    As of May 31, 2010

    As of May 15, 2010 (notice receivable balance is missing)

    adjusted accounts receivable step 4 using nz to control for null values
    Adjusted Accounts Receivable Step 4 (using NZ to control for null values)

    AcctsReceivable: NZ([sales total])-NZ([cash receipts])-NZ([returns])

    As of May 15, 2010

    a r by customer
    A/R by Customer
    • Same basic procedure that was used for summary figure would be used for A/R by customer
    • You would need to use grouping feature in QBE
    • Include customer in query
    slide15

    Data sources

      • Sales table
        • Date and summary cash sales data
        • Note if summary cash sales data not stored, it would be necessary to calculate sales figure pulling data from the sales –inventory table
      • Cash receipts table
      • Sales return table
      • Customer table
    3 net sales by customer
    3. Net Sales by Customer

    outer Join and NZ used

    5 a r balance
    5. A/R balance
    • The following queries will be used to get the A/R balance
      • Net Sales by customer
      • Cash receipts by customer associated with sales events
    5 a r balance1
    5. A/R Balance

    Note: Inner Join has been used

    5 a r balance2
    5. A/R balance
    • Results are missing 1 customers
    • Balance missing for customer
    • Outer join and NZ needed
    5 a r balance3
    5. A/R balance
    • Correct results