Add Accounts Receivable to your Microsoft Access Order Entry & Invoicing Database. Who Owes Money?

[@moodkn]

Lot of Thanks Sir! very helpful exercise

[@599CD]

Most welcome!

[@abdulhamidalhaddadi2255]

Thank you

[@599CD]

You're welcome

[@vincentchikobe649]

Watching it thanks

[@599CD]

Enjoy

[@hkiran3742]

Sir thanks for your tutorial which help me to pass lockdown by watching you videos I created my own order database. Everything is fine but price changes in PRODUCTtbl unitprice changes my old record too. For that I added sellprice in orderitemstbl i have entry price manually which sometimes I afraid may go wrong. Is there a way to default sellprice as my PRODUCTtbl unitprice. Thanks in advance

[@599CD]

Use a Default Value.

[@albazrealestate2859]

Hi Sir, If the customer paid partially by cash or PDC cheques; some of the customer is paying by 4 PDC cheque or 6 PDC,..., Sir, how we can record in this in our customer order table, (with Cheque Number+Chq Dt.+Chq Amount)
Mathew

[@599CD]

Make a payment table to track multiple partial payments. 599cd.com/acd7

[@vincentchikobe649]

Sir how do i pull my last month ordertotals specifically for last month

[@599CD]

599cd.com/Aggregate query with 599cd.com/Criteria

[@Review_MasterBD]

I have order table against Sales Contract,I want to see the orders available and then choose the specific orders and then put an invoice no to them. Generally an invoice consists of many orders.combo box idea wouldn't fit well bcoz I have lots of order/style against a sales contract. Help

[@599CD]

Sounds like a traditional one-to-many relationship between two tables. See 599cd.com/Relationships