Saya...panjang dari Chart of Account bisa dinamis tanpa perlu merubah coding program. Yang saya perlukan adalah : 1. Desain database untuk Financial Accounting (mySQL based) 2. Query untuk menghasilkan laporan yang diinginkan : - Laporan Jurnal - Laporan General Ledger - Laporan Trial Balance - Laporan Balance Sheet - Laporan Profit & Loss
Hi All i have a table like attached image needs first negative balance date followed by second last positive balance means 7769 . ...table like attached image needs first negative balance date followed by second last positive balance means 7769 . -3752.86 2018-08-10 08:06:35 1 min job for expert send query in your reply budget : 500 INR
I have MongoDB collection. I have to group the documents in that collection based on the monthly cycle. For example, the cycle date is 20 of each month. I have to group the documents like 20/06/2018 to 19/07/2018 , 20/07/2018 to 19/08/2018.
I need someone to write a simple sql query to copy fields between tables
...support ( SystemEmailTemplate model), these system emails are sent under some conditions form a SQL query are met (DatabaseQuery model) - System Email should be configured one to one (individually). i.e a URL with the kind of email we want to send as a parameter (SystemEmailQueue atributo template_key model). - Programmed tasks with Crons - Project
...the design, the UI must be exactly the way we want it. we will provide images for that. you can create the website locally and then send us the zipped file for us to upload onto the server. You can even create a query which we can run on the server to create the database. Some of the fields will be dropdown values or Y/N booleans, and there will be
we have a form for insert data, we need on submit to create a query before to process to check if data exist and IF exist show a modal with alert and name of data else process
I need someone freelancer to help me to fix the query below: select count(distinct p.products_id) as total from (products p) left join manufacturers m on (m.manufacturers_id=p.manufacturers_id) left join specials s on p.products_id = s.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on
...moment we have the following scenario: In a Shop System, we can order EBooks (Digital Content). The price is $0 for this books. We have 10 products in the Shopping Cart and send the order and receive an error. That happened with the most combination in the shopping cart, but as well not always. Some products are able to purchase. The error is: Next
Query on Office 365 Excel Online to export the data. No bootstrapping. Need to use Dojo or jQuery, or find a way to get it into that format for me to use.
Project Duration: 1 Hour Project Overview When trying to run this query: SET `description` = REPLACE(`description`, 'â€™', ''') WHERE `description` like 'â€™%' We get the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right synt...
I am currently getting a 500 error on my website. I traced it back to an SQL query (SELECT XYZ FROM zip_code INNER JOIN city ON zip_code.city_id = city.city_id INNER JOIN region ON city.region_id = region.region_id INNER JOIN country ON region.country_id = country.country_id). The INNER JOIN country ON region.country_id = country.country_id part of
The scope of the project is to replicate a single query of a java application to a .Net application. The Java application authenticates as follows: 1. User login to a website (We will provide a username/password) 2. There is a link to login to the application,on this page there i the username/token information that is provided, a JNLP file is being