Search results

How to change text selection colour from default black to other ones in form fields

ok

Hi, CJ, How are you... I have made some changes. Kindly see the attached files. The following points, I want to discuss with you; a. I want three forms for data entry ==> Receipt, Transfer and Adjustment of Inventory. The format which is required I have attached the samples. For Receipt ==>...

Bundle of Thanks, CJ ❤️❤️❤️❤️🌹🌹🌹🌹... For doing me a favour and rebuilding the structure of database. In receipt Main, itemid: 7 ===> Actually, In the main warehouse there are sub warehouses with each have different items. This is the receipt in 2nd warehouse. Thanks again for doing a favour.

Hi, CJ, How are you, I hope so you are doing well... I have to tried to streamline the database as per your advice. Kindly check the database as attached and do me a favour to make a running sum on Union Query and Crosstab Query. I have tried but in vain. I would be very thankful for your kind...

Structure has been changed as suggested. Kindly review the database file and suggest about inventory adjustment tables.

and what about the reporting process of general ledgers? Any how, if you are not using running sum in query then you have required in reports but you could not avoid that process to do.

1. All of the ledgers of accounts are based on running sum. 2. During the audit process the auditor requires ledger details of specific heads of receipts/expenses. 3. Do you think that all of the users of accounting software are acquainted with double entry concepts. All of the accounting...

But the question is, what would be the formula for running sum?

Crosstab is from union query

How to get running sum in union and crosstab query?

Is it concerned with that?

The Main warehouse is sending monthly closing balance report to head office and stock movements of branches report.

See the attached files then suggest. Make delete of queries. I want the QOH and inventory adjustment. Now the theme is in front of you. Suggest me as per the requirement. I will make corrections as what I could do my best.

Before dropping me, I want to share the theme of the project then it's up to you.

Nothing, kindly suggest your expertise

Dear Experts, I have made a QOH value in inventory adjustment form (dlookup function) to see how much QOH for inventory adjustment. But the issue is that QOH is dynamically changing as the QOH gets changed. How to make static as the record saved?

Thanks, CJ_London, For your possible solution of dlookup function. Its works and has provided me the results.

See i have attached again

I have attached database file and screenshot of inventory adjustment form, i want to show QOH in the form but it does not allow me for data entry. Without this it works. What is the solution?